Re: The pain of Excel

On 9/29/24 06:35, Lawrence D'Oliveiro wrote:

On Sun, 29 Sep 2024 04:26:06 GMT, Charlie Gibbs wrote:
 

Is that the one where dates are expressed as the number of days since
January 1, 1900?

 That was some Excel thing.
 The old Macintosh counted time since 1st January 1904, which was cunningly
chosen so they didn’t have to deal with 1900 being an exception to the
rule of a leap year every four years.
 I think Excel did actually consider 1900 to be a leap year at one point.

The problem predated Excel. Microsoft knowingly implemented it that way for compatibility with Lotus 123.