Tag Archives: 1900

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

A Bit Of British Nostalgia For The Holiday.

Anura Guruge, June 8, 2013.
..
...
..
 by Anura Guruge


I, as is no secret, miss my traditional British Holidays — Boxing Day and Hogmanay in particular. So I am going to indulge.

I got a bunch of these historic pictures from Sri Lanka earlier this week.
I shared all of them, via e-mail, with the 4 people I have on my ‘friends & family’ distribution lists. They loved them.

I checked the copyright — yet again.
Pictures before 1923 are now definitely out of copyright — in the U.S. of A.
So, if anybody claims copyright on these I would dearly like to see
their credentials for claiming as such.


A genuine ‘Muffin Man’ in London in 1910.

Click to ENLARGE.

Click to ENLARGE.

Now some of you may know the nursery rhyme. So here is the real thing that went with that rhyme.

'The Muffin Man' from Wikipedia. Click to access.

‘The Muffin Man’ from Wikipedia. Click to access.


Real Estate in London was expensive even in 1910.

A 13 square feet shoe shop in London 1910
— at the bottom …

Click to ENLARGE.

Click to ENLARGE.


More pictures in coming days, if I have the time and I remember.
Crazy busy. Another book is nearly at an end. But, I won’t publish it this year.