J
Jac Tremblay
The year 1900 was not a leap year and we all know that but
Excel will show a 29 of February for that year. We also
know that there was a bug in Lotus 1-2-3 so Microsoft
decided to leave things the way they were in Excel so
Lotus users would have less code to change if they wanted
to switch to Excel.
My question is: "February 29th 1900 is a Wednesday. That
makes the 1st of April 1900 a Thursday (it should have
been a Wednesday). Every following day, including today,
is then offset by one week day. How come Excel calculates
today, September 8th 2003, as a Monday. Where in between
those two dates did Excel correct that mistake."
Thank you.
Excel will show a 29 of February for that year. We also
know that there was a bug in Lotus 1-2-3 so Microsoft
decided to leave things the way they were in Excel so
Lotus users would have less code to change if they wanted
to switch to Excel.
My question is: "February 29th 1900 is a Wednesday. That
makes the 1st of April 1900 a Thursday (it should have
been a Wednesday). Every following day, including today,
is then offset by one week day. How come Excel calculates
today, September 8th 2003, as a Monday. Where in between
those two dates did Excel correct that mistake."
Thank you.