ended3월 15일· 1 sources

Excel incorrectly assumes that the year 1900 is a leap year

Excel이 1900년을 윤년으로 잘못 처리하는 이유

Why it matters

Microsoft Excel treats 1900 as a leap year, inheriting the bug from Lotus 1-2-3 for serial date compatibility. Correcting it would shift nearly all existing dates by one day and break cross-program compatibility, so Microsoft intentionally leaves it unfixed. The only practical impact is incorrect WEEKDAY values for dates before March 1, 1900.

1
Sources
+0
24h
Growth
189d
Active
ExcelLotus 1-2-31900 윤년 버그날짜 직렬 시스템하위 호환성

Sources

Related Issues