Excel incorrectly assumes that the year 1900 is a leap year
4 hours ago
- #Excel
- #Leap Year
- #Compatibility
- Microsoft Excel incorrectly treats the year 1900 as a leap year due to historical compatibility with Lotus 1-2-3.
- Correcting this behavior would cause issues like date shifts, incorrect function returns, and compatibility problems with other programs.
- The only known issue with the current behavior is incorrect WEEKDAY function values for dates before March 1, 1900, which is rare.
- Excel correctly handles all other leap years, including non-leap century years like 2100.