Advertisements

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 365.242199 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: , , , , , , , , , , , ,

About Anura Guruge

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: