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

[David Gilbert <david gilbert jrefinery com>]

Here's a link to the Microsoft explanation.  It sounds reasonable to me:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q181370

Regards,

Dave Gilbert.

On Thursday 20 December 2001 20:42, Neil Booth wrote:
> Neil Booth wrote:-
>
> > Andreas J. Guelzow wrote:-
> >
> > > Could somebody with access to XL please confirm that in XL
> > > DATEVALUE("1/1/1900")
> > > evaluates to 1 ?
> >
> > Yes, it's a well-known bug; they forgot about 29/2/1900.  Various
>
> Sorry, s/forgot about/erroneously included/
>
> 8-)
>
> Neil.