Microsoft KB Archive/23556

The Year 1900 Is Not a Leap Year PSS ID Number: Q23556 Article last modified on 03-26-1992 PSS database name: D_MPlan

3.02

MS-DOS

Problem: There is an error that revolves around the fact that the year 1900 was not a leap year. Multiplan allows you to enter the date 2/29/1900 even though this date does not exist. Because of this, the serialized dates are incorrect for January and February 1900. They are off by one day. The serialized dates begin correcting themselves on March 1, 1900.

Response: This is not a problem, but is by design. The reason for this adjustment is to make Multiplan’s serial date numbers compatible with Lotus 1-2-3. Lotus has a problem that causes the dates to be wrong. This will not be changed at this time. What you might do to correct this is do a -1 day adjustment to the dates you use prior to March 1, 1900 in order to obtain the correct serialized date.

Copyright Microsoft Corporation 1992.