Forum Discussion

Copper Contributor

Oct 02, 2018

Excel for Mac 1900 date system seems to add an extra day ?

When I recently switched between the 1904 and 1900 date systems, I noticed an anomaly. The number of days between the two systems is 1462. The documentation states "1,462 days is equal to four years ...

Excel on Mac

SergeiBaklan

Diamond Contributor

Oct 02, 2018

Hi Craig,

That's know bug in Excel for Windows, see https://support.microsoft.com/en-us/help/214326/excel-incorrectly-assumes-that-the-year-1900-is-a-leap-year.