Microsoft KB Archive/26869

Entering 2/29 on a Leap Year Displays an Incorrect Date PSS ID Number: Q26869 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00

WINDOWS

Summary:

If you enter “2/28” in a cell that has been formatted with the d-mmm format, the correct entry of “28-Feb” with the date of “2/28/1992” is displayed in the formula bar. However, entering “2/29” displays “1-Feb” with “2/1/1929” in the formula bar.

More Information:

The problem is related to leap years and can be corrected by entering the entire date into the cell. In the above example, enter “2/29/1992”.

Microsoft has confirmed this to be a problem in Microsoft Excel versions 2.0, 2.01, 2.1, and 3.0. This problem was corrected in Microsoft Excel version 4.0.

Additional reference words: 2.00 2.10 3.00

Copyright Microsoft Corporation 1993.