How to Use This Tool
Type a serial number to get the date, or pick a date to get the serial. Both directions handle the 1900 quirk so the answers match what Excel itself shows.
How Excel stores a date
As a plain number: the count of days since an origin, with the fractional part being the time of day. Serial 45658 is 1 January 2025; 45658.5 is midday on that date. That is why a date cell reformatted as a number suddenly shows five digits, and why subtracting two dates gives you a day count for free.
Times work the same way. 0.25 is six in the morning because it is a quarter of the way through the
day, and 1.5 is a day and a half. A duration over 24 hours only displays correctly with the
[h]:mm format; without the brackets Excel wraps it at midnight.
The bug that cannot be fixed
Excel treats 29 February 1900 as a real date. It was not — a century year is a leap year only if divisible by 400, and 1900 is not. The error came from Lotus 1-2-3, and Excel reproduced it deliberately so that Lotus files would convert without every date shifting.
Forty years later it is load-bearing. Removing it would silently change one date in every spreadsheet ever saved, so it stays. The practical effects:
- Serials 1 to 59 are one day out compared with any correct day-count from the same origin.
- Serial 60 maps to a date that does not exist. This tool reports it rather than quietly rounding to 28 February or 1 March.
- Dates from March 1900 onward are all correct, because the phantom day has been absorbed. In practice this means the bug never bites unless you handle nineteenth or early twentieth century dates.
The 1904 system
Excel for Mac historically counted from 1 January 1904, which sidesteps the 1900 bug entirely and creates a different problem: the two systems are 1,462 days apart. Copy dates from a 1904 workbook into a 1900 one and every date moves by four years and a day, with no warning.
The setting lives in the workbook, not the application, so a file made on an old Mac carries it forever. Modern Excel defaults to 1900 everywhere, but inherited files still turn up. If a whole column of dates is out by roughly four years, this is almost always why.
Practical notes
- Serial 0 displays as 0 January 1900, which is Excel's way of saying "no date". It is not a real day.
- Negative serials are not supported in the 1900 system, so dates before 1900 cannot be stored as dates at all — they have to be text, which is why historical datasets in spreadsheets are so often broken.
- A date that will not convert is usually text that looks like a date. If it is left-aligned by default in the cell, Excel thinks it is a string.
