A data analyst imports a CSV file from a banking system and finds a column of numbers like 45292, 45293, 45294 instead of dates. The bank exported dates as Excel serial numbers. This converter turns those numbers back into readable calendar dates so the analyst can continue working.
A developer building a VBA macro needs to pass a date to an Excel worksheet function. Excel internally stores dates as serial numbers starting from January 1, 1900. The developer uses this tool to find that March 15, 2024 is serial 45366, then uses that value in the macro.
An accountant working with legacy Mac spreadsheets encounters dates that are off by four years. The file was created using the 1904 date system (old Mac default). By switching the converter to the 1904 system, the accountant can verify the correct dates and troubleshoot the discrepancy.
A project manager exports Gantt chart data from Excel to a project management tool. The tool expects ISO 8601 date strings, but Excel provides serial numbers. This converter bridges that gap by translating serial 45292.5 into 2024-01-01 12:00:00.
Excel stores dates as sequential serial numbers. In the 1900 date system (the Windows default), serial 1 represents January 1, 1900. Each subsequent day increments the serial by 1. So serial 2 is January 2, 1900, serial 33 is February 2, 1900, and serial 45292 is January 1, 2024.
Time is stored as a fractional part of the serial number. The decimal portion represents the fraction of a 24-hour day. For example, 0.5 is noon (12:00 PM), 0.25 is 6:00 AM, and 0.75 is 6:00 PM. So serial 45292.5 means January 1, 2024 at 12:00 PM.
The 1900 system has a known bug: it incorrectly treats 1900 as a leap year. February 29, 1900 never existed, but Excel assigns it serial 60. This means for serial numbers 60 and above, the actual date is one day behind what a naive calculation would produce. This converter handles that bug automatically.
The 1904 date system was the default for Excel on classic Mac OS. It starts counting from January 1, 1904, so serial 1 is January 2, 1904. The difference between the two systems is 1,462 days. If you open a Mac-created file in Windows Excel and see dates four years off, the date system mismatch is the cause.
Input
Serial 45292 (1900 system)
Output
January 1, 2024 (Monday)
New Year's Day 2024. No time fraction, so midnight (00:00:00).
Input
Serial 45292.5 (1900 system)
Output
January 1, 2024 at 12:00 PM (Monday)
The 0.5 fraction means noon, halfway through the day.
Input
Serial 45000 (1900 system)
Output
February 9, 2023 (Thursday)
A common serial number when working with 2023 data exports.
Input
Date: March 15, 2024 at 3:30 PM (1900 system)
Output
Serial 45366.645833
The 0.645833 fraction represents 3:30 PM (15.5/24 = 0.645833).
Pitfalls to avoid
What is an Excel serial date number?
Excel stores dates as sequential numbers called serial values. In the 1900 date system, serial 1 is January 1, 1900. Each day adds 1 to the serial. So January 2, 1900 is serial 2, and January 1, 2024 is serial 45292. Times are stored as decimal fractions of a day.
Why does Excel think 1900 is a leap year?
Excel inherited this bug from Lotus 1-2-3 for backward compatibility. The year 1900 is not a leap year because it is divisible by 100 but not by 400. However, Excel includes a phantom February 29, 1900 as serial 60. This affects serial numbers 60 and above by shifting them one day.
What is the difference between the 1900 and 1904 date systems?
The 1900 system (Windows default) starts counting from January 1, 1900. The 1904 system (old Mac default) starts from January 1, 1904. The difference is 1,462 days. If you open a file created with the other system, dates will appear off by about four years.
How do I convert an Excel serial to a regular date?
Enter the serial number in the converter above and select the correct date system. The tool handles the 1900 leap year bug and time fractions automatically. You can also use the Excel formula =TEXT(serial,"mm/dd/yyyy") in a spreadsheet.
What does the decimal part of an Excel serial mean?
The decimal portion represents the time of day as a fraction of 24 hours. 0.5 is noon, 0.25 is 6:00 AM, 0.75 is 6:00 PM, and 0.0 is midnight. For example, 45292.375 means January 1, 2024 at 9:00 AM.
Can I use this converter for Google Sheets dates?
Yes. Google Sheets uses the 1900 date system by default, so the serial numbers are the same as Excel for Windows. Enter the serial number with the 1900 system selected.
How do I switch date systems in Excel?
In Excel, go to File > Options > Advanced > When calculating this workbook > Use 1904 date system. Be cautious: changing the system after entering dates will shift all existing dates by 1,462 days.
Is the Excel serial the same as a Unix timestamp?
No. Excel serials count days from January 1, 1900 (or 1904). Unix timestamps count seconds from January 1, 1970. They are different numbering systems. Use the Unix Timestamp Converter for Unix time conversions.
This converter uses the standard Excel serial date algorithm with automatic handling of the 1900 leap year bug. For serial numbers below 60 in the 1900 system, a one-day correction is applied. Results match Excel's internal date representation for both the 1900 and 1904 systems.