Advertisements
April 28, 2018  

Error In MS Excel 2016 — Treats ‘1900’ As A Leap Year, And It Was NOT!

by Anura Guruge

Click picture to ENLARGE.

IF you really were a Year 2000 aficionado and followed all of the Y2K drama you would know that all centurial years are NOT Leap Years.

For centurial years it is NOT enough to be divisible just by 4. It also has to be divisible by 400. This is was another major improvement to the Gregorian calendar to keep the year lengths as close to days as possible.

So, 1700, 1800, 1900 were NOT LEAP YEARS since they are NOT divisible by 400.

But, 2000 was, because it is divisible by 400.

Excel has 1900 as a LEAP YEAR.

Yes, I am probably the ONLY one in the whole world that would NOTICE and CARE.

But, I do a LOT of date span calculations — example when I am working out ICE-OUTS for lakes. In such calculations, being the pedant I am, I take into account Leap Years. Otherwise you are mistating some date spans.

That is how I noticed.

You can check it out.

Related posts:
 Search ‘Excel’.

by Anura Guruge

Advertisements

Tags: 1900, 2000, =deatediff, , centurial years, date spans, datediff, Excel, Excel 2016, Ice-Out, leap year, Microsoft, year 1900

About Anura Guruge

See 'The Blogger' on my https://nhlifefree.com/ blog.

Leave a Reply

%d bloggers like this: