Error in Excel date calculations

[niels]

Year 1900 were not leap years, but Excel calculate with a leap year in 1900.
The date: February 29, 1900 should not exist, but it is it in Excel 2000,
2003 and 2007.
Excel makes errors in the date calculations involving the dates January 1,
1900 to March 1, 1900.
Excel calculate that the first of january, 1900 was a sunday, it was a
monday.

Quote from Wikipedia:
"Years that are evenly divisible by 100 are not leap years, unless they are
also evenly divisible by 400, in which case they are leap years. For
example, 1600 and 2000 were leap years, but 1700, 1800 and 1900 were not."

Best regards
Niels

 

[joeu2004]

The date: February 29, 1900 should not exist, but it is
it in Excel 2000, 2003 and 2007.

..... And in Excel 2010.

You are correct: Excel is wrong. It is a known problem; and like most
known problems, Microsoft has never fixed it, or at least provided a
calculation option to fix it.

FYI, VBA does not have this defect, at least in Excel 2003 and later. And
that causes another problem: VBA and Excel date serial numbers differ by
one before Mar 1, 1900.

 

[PeCoNe]

Op 2012-05-29 17:03, joeu2004 schreef:

.... And in Excel 2010.

You are correct: Excel is wrong. It is a known problem; and like most
known problems, Microsoft has never fixed it, or at least provided a
calculation option to fix it.

FYI, VBA does not have this defect, at least in Excel 2003 and later.
And that causes another problem: VBA and Excel date serial numbers
differ by one before Mar 1, 1900.

See remarks MS:
http://support.microsoft.com/kb/214326/en-us

Bye Peter

 

[niels]

Op 2012-05-29 17:03, joeu2004 schreef:
See remarks MS:
http://support.microsoft.com/kb/214326/en-us

Bye Peter

Many thanks to both of you for your responses.
/Niels