Thread: Excel date bug?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Excel date bug?
On 13 Sep 2006 17:09:17 -0700, wrote:

Hi,

It seems that in Excel you can have 2/29/1900 although that day did not
exist?

That would mean that the number of days between 1/1/1990 and, say,
5/1/2006 is not 38838 or (38838-1, if you will) but rather 38837 or
(38837-1, if you will).

Correct?

Thanks!

Aaron Fude

That is correct. I am told that Microsoft coded it that way to duplicate the
bug in the then dominant Lotus 1-2-3 spreadsheet program.
--ron
Reply With QuoteReply With Quote