Re: M$ Excel Supreme Stupidity

On 1/17/25 11:39 AM, Chris Ahlstrom wrote:

Farley Flud wrote this post while blinking in Morse code:
 

Wanna good laugh?
>
Fire up Microcrap Excel.  Open a blank workbook and format
a cell as "Date."  (Accept the default display format.)
>
Now in that same cell enter "60."
>
What do you see?  Answer: “February 29, 1900” (or whatever
display format you have chosen).
>
The problem is that Feb 29, 1900 does not exist!
>
The year 1900 is not a leap year!
>
I'm seeing this right in front of me right now and I am using
the very latest version of Microcrap Excel.
>
OMFG!  What junk!
>
I thank John Walker for this:
>
https://www.fourmilab.ch/documents/calendar/

 In LibreOffice, it's just "60". When you apply the "Date" format, the
result is 2/28/00;  or choose the full date format to see the 1900.

Looking into the Excel bug, it actually appears to be more than merely that 2/29/1900 doesn't exist:
Using a value of 1 ... it reports as being 1/1/1900.  Good enough, but it also reports that that was a Sunday.  But calendars report that 1/1/1900 was actually a Monday
Values 2 thru 59:  same as above: the day of the week is off by one.
60:  the Wednesday, 2/29/1900 error
61 & higher:  Thursday 3/1/1900 .. so the day of week is now correct.
-hh