← All text tools

Excel serial date converter

Convert Excel serial numbers such as 45000 into calendar dates and dates back into serials in the 1900 or 1904 system, singly or as a list.

  • Free
  • No sign-up
  • Works on any device

About Excel serial date converter

Excel stores a date as a serial number, the count of days since a start date, with the time as the fraction of a day. In the default 1900 system serial 1 is 1 January 1900, so 45000 is 15 March 2023 and 44927 is 1 January 2023. Older Mac files use the 1904 system, where 0 is 1 January 1904. Excel wrongly treats 1900 as a leap year, creating a 29 February 1900 that never existed, which this page flags. Convert in either direction, with the weekday, or paste a list.

How to use Excel serial date converter

  1. Pick serial to date or date to serial, and the date system of the workbook.
  2. Type the serial number, or choose the date and an optional time.
  3. Read the result and paste a list below to convert many values at once.

Why use this tool?

Also known as

Frequently asked questions

What date is Excel serial 45000?

15 March 2023, a Wednesday, in the 1900 date system. Serial 44927 is 1 January 2023.

Why does Excel think 1900 was a leap year?

Excel copied the behaviour of Lotus 1-2-3 for compatibility. The bug means serial 60 is the non-existent 29 February 1900, and earlier dates are off by one day.

How do I know if my file uses the 1904 system?

In Excel for Windows see File, Options, Advanced and look for the 1904 date system box. A workbook date that is 1,462 days off usually means the wrong system.

Is Excel serial date converter free?

Yes. Excel serial date converter on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put Excel serial date converter on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools