News for hackers. Stuff that matters.
Re:Epochalypse by aidenn0 on Saturday January 07, 2023 @12:12AM (#34285436)
Lotus 1-2-3 used an epoch from 1900-01-01, but it had a bug where it considered all years divisible by 4 to be leap years.

When Excel came around, it needed to be compatible with 1-2-3, so it used the same date format, and to be compatible it considers 1900 to be a leap year.

Re:Epochalypse by zdw on Saturday January 07, 2023 @12:27AM (#34285519)
Excel has two date systems, with either a 1900 or 1904 start date:

https://support.microsoft.com/en-us/office/date-systems-in-e...

The original Excel was for the Macintosh and had the 1904 date system, and was later brought to Windows where the 1900 date system was used.

Re:Epochalypse by cookingrobot on Saturday January 07, 2023 @01:24AM (#34285737)
Here’s a great story about the ongoing impact of those decisions. https://www.joelonsoftware.com/2006/06/16/my-first-billg-rev...