Error in Excel date calculations

N

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
 
J

joeu2004

niels said:
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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top