BUG: Excel Date Issue

[Bill Smith]

I think there is a bug in the Excel Date calculations. I am using Office
2003 and here is what I do

Under Tools->Options->Calculation, make sure you are *NOT* using 1904 date
formats

In 3 cells, enter the following numbers

1
32
60

Select the cells and format them as dates. You get:

1/1/1900 Correct
2/1/1900 Correct
2/29/1900 ***WRONG *** ????

1900 is not a leap year so how can this be?

 

[Peo Sjoblom]

It's a bug that comes from Lotus 123 and to be compatible MS knowingly added
this bug to Excel
That was of course during the days when Lotus ruled the spreadsheet world
<g>

Regards,

Peo Sjoblom

 

[D T]

I think that you will find that 1900 was a leap year. The rule is
years divisable by 400 are not leap years not every century. 1600 &
2000 were not leap years, the rest are. Next one that is not is 2400

DT

 

[Dave Peterson]

I believe you got that backwards.

http://scienceworld.wolfram.com/astronomy/LeapYear.html