Serial Number To Date Converter

Microsoft Excel uses a date system where dates are recorded as the number of days from the start of year 1900 (1 => 1900-01-01) or 1904 (1 => 1904-01-02). Excel typically displays dates correctly but sometimes you may encounter underlying date serial numbers.

The easiest way to convert Excel date serial numbers to dates is by pasting them into Excel and changing the format to "Short Date" or "Long Date" in the Home ribbon.

Alternatively, use the form below to enter one or more Excel date serial numbers (one per row) and click Convert.

All data is processed directly in your browser, ensuring your privacy. No user information is stored.

Please note that this service is provided without warranty or support. I am not responsible for any damages or inaccuracies that may arise from the outputs or the use of this service.

More Information


YYYY-MM-DD