| 3098 |
1999-10-05 19:32:00 |
In your story about Excel's 'Y1.9K problem' you didn't mention that Excel also thinks 1900 was a leap year when, of course, it wasn't. (Years ending in __00 must be divisible by 400 to be leap years - this is the root cause of the Feb 29 problem associated with Y2K). Set up a date field in Excel and enter 60 - it will display 29 Feb 1900, a day which didn't exist. Therefore any calculations spanning that date will surely give incorrect totals if someone is trying to calculate the number of days involved. |
Guest (0) |