Excel thinks 29 February 1900 existed — it didn’t.

Wacky WorldExcel & Office

1900 was not a leap year, but Excel treats it as one. The bug was copied on purpose from Lotus 1-2-3 so that spreadsheets moved between the two programs would keep the same date serial numbers. It is still there today for compatibility.

Another wacky fact → All facts