The Strange February 29, 1900
Key points
- Enter 60
- See the result
- Learn why
In Excel Serial Date, entering 60 shows it is February 29, 1900 in Excel.
Steps
- Enter 60
- See the result
- Learn why
That day never existed and is kept for compatibility with old spreadsheets.
Use "Excel Serial Number and Date Converter" (free)
Tools that go well with this
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- UNIX Timestamp Converter: Convert between UNIX time and dates.
- Convert Between Western Years and Japanese Eras: Convert between AD years and Japanese eras.