Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Excel incorrectly assumes that the year 1900 is a leap year

learn.microsoft.com

Post reply on HN
Print view View original

1–10 of 36 posts

Re: Excel incorrectly assumes that the year 1900 is a leap year

#2

Post by nippoo »

In other "incorrect calendars" bugs, there's the Rockchip RK808 RTC, where the engineers thought that November had 31 days, needing a Linux kernel patch to this day that translates between Gregorian and Rockchip calendars (which are gradually diverging over time).

Also one of my favourite kernel patch messages: https://git.kernel.org/pub/scm/linux/kernel/git/torvalds/lin....

Re: Excel incorrectly assumes that the year 1900 is a leap year

#4

Post by etothepii »

darknavi wrote: post #3

> Applies to: Microsoft Excel for Mac 2011, Excel for Microsoft 365 for Mac, Microsoft Office Excel 2003, Microsoft Office Excel 2007, Excel 2010, Excel 2013, Excel 2016

This will never stop as it would require either the reference date to be changed or fir all dates in all saved spreadsheets to be off by one.

Re: Excel incorrectly assumes that the year 1900 is a leap year

#6

Post by gerdesj »

nippoo wrote: post #2

In other "incorrect calendars" bugs, there's the Rockchip RK808 RTC, where the engineers thought that November had 31 days, needing a Linux kernel patch to this day that translates between Gregorian and Rockchip calendars (which are gradually diverging over time). Also one of my favourite kernel patch messages: https://git.kernel.org/pub/scm/linux/kernel/git/torvalds/lin... .

To be fair, that's nowhere near as daft as september, october, november, december. Latin for seven, eight, nine, and ten is: septem, octem, novem, decem. Those are the nineth, 10th, 11th and 12th months.

Edit: Whoops, correct eng -> latin nums

Re: Excel incorrectly assumes that the year 1900 is a leap year

#9

Post by emmelaich »

gerdesj wrote: post #6
nippoo wrote: post #2

In other "incorrect calendars" bugs, there's the Rockchip RK808 RTC, where the engineers thought that November had 31 days, needing a Linux kernel patch to this day that translates between Gregorian and Rockchip calendars (which are gradually diverging over time). Also one of my favourite kernel patch messages: https://git.kernel.org/pub/scm/linux/kernel/git/torvalds/lin... .

To be fair, that's nowhere near as daft as september, october, november, december. Latin for seven, eight, nine, and ten is: septem, octem, novem, decem. Those are the nineth, 10th, 11th and 12th months. Edit: Whoops, correct eng -> latin nums

You may know this but originally they were 'correct' because the start of the year was March.
Post reply on HN