---
title: Excel has a fake day that Microsoft won't fix
description: >-
  Excel thinks February 29, 1900 was a real day. It wasn't. 1900 was not a leap year. Microsoft
  knows, and the bug stays.
url: https://expiredqueues.com/watch/excel-has-a-fake-day-that-microsoft-wont-fix/
markdown: https://expiredqueues.com/watch/excel-has-a-fake-day-that-microsoft-wont-fix/index.md
image: >-
  https://expiredqueues.com/images/og/watch-excel-has-a-fake-day-that-microsoft-wont-fix-f7c66366.jpg
---

[All videos](https://expiredqueues.com/watch/index.md)

# Excel has a fake day that Microsoft won't fix

15 Nov 2026

[Excel has a fake day that Microsoft won't fix](https://www.youtube-nocookie.com/embed/x0d_7IiCG-k)

[Watch on YouTube](https://www.youtube.com/shorts/x0d_7IiCG-k)

Excel thinks February 29, 1900 was a real day. It wasn't. 1900 was not a leap year. Microsoft knows, and the bug stays.

Lotus 1-2-3 had the bug first. Excel copied it on purpose, so old spreadsheets would open with the same dates. Fix it today and almost every date in every Excel sheet shifts by one day.

That is Hyrum's Law. With enough users, every behavior of your system will be depended on by somebody. Even the bugs. Hyrum Wright saw it at Google, where a simple library change could break systems far away.

The Go team went the other way. They made map iteration order unpredictable on purpose, so nobody could rely on it.

What bug is your team keeping alive because someone depends on it? Tell me in the comments.

Sources: Microsoft, "Excel incorrectly assumes that the year 1900 is a leap year": <https://learn.microsoft.com/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year> Hyrum Wright, Hyrum's Law: <https://www.hyrumslaw.com/> Go 1 Release Notes, "Iterating in maps": <https://go.dev/doc/go1>

More notes on web development: <https://expiredqueues.com/>

## Structured data

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "VideoObject",
      "name": "Excel has a fake day that Microsoft won't fix",
      "description": "Excel thinks February 29, 1900 was a real day. It wasn't. 1900 was not a leap year. Microsoft knows, and the bug stays.",
      "thumbnailUrl": [
        "https://expiredqueues.com/images/videos/x0d_7IiCG-k.jpg"
      ],
      "uploadDate": "2026-11-15T12:00:26+00:00",
      "embedUrl": "https://www.youtube.com/embed/x0d_7IiCG-k",
      "url": "https://expiredqueues.com/watch/excel-has-a-fake-day-that-microsoft-wont-fix/",
      "sameAs": "https://www.youtube.com/shorts/x0d_7IiCG-k",
      "publisher": {
        "@type": "Organization",
        "name": "Expired Queues",
        "url": "https://expiredqueues.com/"
      }
    },
    {
      "@type": "BreadcrumbList",
      "itemListElement": [
        {
          "@type": "ListItem",
          "position": 1,
          "name": "Home",
          "item": "https://expiredqueues.com/"
        },
        {
          "@type": "ListItem",
          "position": 2,
          "name": "Watch",
          "item": "https://expiredqueues.com/watch/"
        },
        {
          "@type": "ListItem",
          "position": 3,
          "name": "Excel has a fake day that Microsoft won't fix",
          "item": "https://expiredqueues.com/watch/excel-has-a-fake-day-that-microsoft-wont-fix/"
        }
      ]
    }
  ]
}
```
