Deltadays and date functions.

[toml_12953]

(05-11-2017 05:03 PM)Dieter Wrote:  

(05-11-2017 11:33 AM)Vtile Wrote:  Quickly to excel ... Atleast this new Office365 version I have at my disposal does give #value-error for dates before 1.1.1900 when trying to apply ie. Dates, or DATEVALUE functions (non-VBA functions) to it.

Sure, the earliest allowed date is 1 Jan 1900. But the first correctly handled date is 1 March 1900. #-)

BTW, here is what Microsoft says on this issue. Read it and have a good laugh.

FTR: the mentioned programs Lotus 1-2-3 and MS Multiplan appeared in the early Eighties, about the same time as the Commodore 64 and the HP-41CX. #-)

Dieter

I'm surprised MS didn't lobby to have 1900 officially changed to be a leap year!

Tom L