Unit Converter
Excel Serial Date Converter
Convert Excel serial numbers to calendar dates and back, explicitly choosing the workbook’s date system.
Excel Serial Date Converter examples
| Input | Expected result |
|---|---|
| 40729; 1900 system | 2011-07-05T00:00:00.000 |
| 39267; 1904 system | 2011-07-05T00:00:00.000 |
| 40729.5; 1900 system | 2011-07-05T12:00:00.000 |
| 59 / 60 / 61; 1900 system | 1900-02-28 / fictional-date error / 1900-03-01 |
Supported units & limits
Product scope: 1900 serials start at 1; 1904 serials start at 0. Both end on 9999-12-31. Negative serials and 1900 serial zero are not supported. Serial input allows 1–7 integer digits, an optional plus, and up to 12 decimal places; no exponents or separators. Fractional days round to the nearest millisecond, exact ties upward. Any value in fictional 1900 serial day 60, or rounding into it, is rejected. Date input is YYYY-MM-DD, optionally followed by T or a space and HH:mm[:ss[.SSS]]; date-only means midnight as a workbook calendar value. No time zone is assigned or converted. Serial output rounds to 12 decimal places, sufficient to retain the millisecond on re-entry. This tool does not read workbooks or infer their settings.
Common mistakes
Check the workbook’s date system instead of guessing from a serial. Serial 60 in the 1900 system is not a valid Gregorian date. A value ending in .5 represents noon, not half a second. Calendar values in Excel do not identify a UTC instant unless you separately know their time zone. The displayed normalized serial reflects millisecond rounding. Older Mac workbooks may use the 1904 system; choose it in the Excel Serial Date Converter, or dates come out four years and a day early.
Privacy
Conversions run in your browser. This site does not upload or store the values you enter. We use Google Analytics, loaded through Google Tag Manager, to count page visits and see which tools are used; Google may set cookies for this. The hosting server may keep standard access logs when you load a page.
Conversion guide
Match the workbook before interpreting a number
Check the workbook date-system setting, select the direction and enter the serial or calendar value. Review the other result after rounding. Copy the main result. Keep the workbook’s time-zone convention separately; no device local zone or external API participates in the conversion.
Excel Serial Date Converter FAQ
Which system should I select?
Use the date system configured for the source workbook. The converter does not infer it from a number or a file.
Why does serial 60 produce an error?
The 1900 system preserves Excel’s historical leap-year compatibility behavior. Gregorian 1900-02-29 does not exist, so the converter refuses to silently map it to another date.
What does the fractional part mean?
It is the fraction of a 24-hour day. For example .5 is 12:00 noon. This converter rounds it to the nearest millisecond.
Are the results in UTC?
No. They are calendar values without a zone. Assign the intended zone separately before converting them to Unix timestamps.