Deltadays and date functions.

[Dieter]

(05-10-2017 07:55 PM)Vtile Wrote:  You are correct, but I think miscalculation on the excel did relate how it handles the year 1900 as its day function seems to start at 1.1.1900 (IIRC).

I am not sure if this has been changed in recent versions of Excel, but actually the date calculations are incorrect for dates before 1 March 1900. Although 1900 was not a leap year, you may enter 29 Feb 1900 without an error message, and the difference between 1 March 1900 and 28 Feb 1900 is miscalculated as 2 days instead of one.

As with several other functions, the golden rule is: "code your own". VBA exists, and it allows doing things right that the built-in functions don't.

Dieter