How to Use the Excel Serial Date to Calendar Date Converter

Type an Excel/Sheets serial number (e.g.
45658
) into the serial field, or click the swap icon and pick a calendar date instead.
Click Convert. The tool runs Excel's exact 1900-system arithmetic instantly in your browser.
Read the result — a real calendar date, or the serial number, along with a note whenever the historical leap-year bug is relevant.
Nothing you type is uploaded anywhere — this is pure date arithmetic running as JavaScript in your browser tab.

What an Excel Serial Date Actually Is

Excel (and Google Sheets, which copied Excel's scheme for compatibility) doesn't store dates as text — it stores every date as a plain integer counting days since an epoch, with the time-of-day as a fractional part. Under the default "1900 date system," serial 1 = January 1, 1900, serial 2 = January 2, 1900, and so on. This tool implements exactly that numbering, one calendar day at a time, verified against known reference values (serial 45658 is January 1, 2025 — a commonly cited constant, and one this tool reproduces exactly).

The 1900 Leap-Year Bug, Explained Honestly

Here is the part most converters get wrong or skip entirely: Excel's serial numbering includes a date that never existed.

1900 was not a leap year under the real Gregorian calendar rule (century years are leap years only if divisible by 400; 1900 is divisible by 100 but not 400, so it was a common year). Despite that, Excel's serial 60 is treated as "February 29, 1900" — a date that never happened.

This bug did not originate with Microsoft. Lotus 1-2-3, the dominant spreadsheet of the early 1980s, implemented leap years with the naive rule "divisible by 4," which incorrectly includes 1900. When Excel launched, Microsoft deliberately reproduced Lotus's exact serial numbering — including this bug — so that files could move between the two programs without every date shifting by a day. Microsoft has stated publicly it will never fix this: doing so now would shift every date in every existing Excel file ever created by one day, breaking far more than it would fix.

The practical effect: serials 1-59 map onto real dates January 1 through February 28, 1900. Serial 60 is the fictitious February 29. Serial 61 is real again — March 1, 1900 — but every date from March 1, 1900 onward is numbered one higher than a "correct" calendar-based count would give it, permanently, because of that one phantom day. This tool implements that exact behavior: ask it for serial 60 and it tells you plainly that this is a fictitious date, rather than either crashing or quietly returning a wrong real date. Ask it to convert the (impossible) date "1900-02-29" back to a serial and it explains why there isn't one, instead of inventing a number.

Worked Example

Serial 45658 → January 1, 2025. Serial 1 → January 1, 1900 (the epoch itself). Serial 59 → February 28, 1900 (the last real date before the phantom day). Serial 61 → March 1, 1900 (the first real date after it).

The Other System: 1904 Dates (Not Covered Here)

Older Excel-for-Mac files sometimes use a completely separate "1904 date system," where serial 0 = January 1, 1904, and the 1900 leap-year bug doesn't apply at all (no phantom day). This tool implements only the far more common 1900 system (the default in every modern Excel and every Google Sheet) — if a workbook's dates look off by exactly 4 years and 1 day from what this tool gives you, that workbook is almost certainly using the 1904 system instead.

Frequently Asked Questions

Why does Excel still have this bug in 2026? Microsoft has explicitly stated it will not fix it, because doing so would retroactively shift every date value in every existing spreadsheet by one day.

Does Google Sheets have the same bug? Yes — Google Sheets deliberately matches Excel's serial-date numbering, phantom leap day and all, for file-format compatibility.

Is my input uploaded or stored anywhere? No. The conversion runs entirely as JavaScript inside your browser tab — nothing is sent to a server, logged, or stored.

Is this tool free? Yes, completely free, no login, no limit.