Excel date bug?
 

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

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

Excel date bug?
 

You meant 1/1/1900, not 1/1/1990?

" 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