Excel consider the day 29-02-1900 while it never happened

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1900 was not a leap yr and exel considers it to be leap yr. Fortunetly the
weekdays are wrong only before the day 61 (1-03-1900) but the counting of
days IS wrong from that date on. This could be a pain while working with
ancient dates.
Will this be fixed?
 
Julius said:
1900 was not a leap yr and exel considers it to be leap yr.
Fortunetly the weekdays are wrong only before the day 61 (1-03-1900)
but the counting of days IS wrong from that date on. This could be a
pain while working with ancient dates.
Will this be fixed?
Click to expand...

I hope not!

I believe it was a deliberate error coded in to make excel work the
same as Lotus 123 (the dominant spreadsheet application for many
years).

If it was changed now, then all the models that adjust for the
documented error, will be broken, and that would be far worse.

HTH,

Alan.
 
Back
Top