Re: XL: DATEVALUE("1/1/1900")

Andreas J. Guelzow wrote:-

Could somebody with access to XL please confirm that in XL 
evaluates to 1 ?

Yes, it's a well-known bug; they forgot about 29/2/1900.  Various
other programs have had to break for compatibility, and now that
so many sheets are broken with it, MS won't fix it.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]