Deltadays and date functions.

[Vtile]

(05-10-2017 02:42 PM)Don Shepherd Wrote:  

(05-10-2017 01:28 PM)Vtile Wrote:  So which ones are correct?

The 12c, 17b, 17bii, and 65 (using the algorithm I mentioned) all return 73049 for dbd(2/28/1900,2/28/2100).

Thank you for the check, I think it is excels date format related thing, suprising that it starts from 1900 and not even from 1800s.

I start to think that I will adapt that same algorithm also (or just go with http://www.hpmuseum.org/forum/thread-6741.html). It is suprisingly annoying task to get everything sorted out and functioning with a few lines of code even with small time window.