- Free
- No sign-up
- Works on any device
No tool matches your search.
- Free
- No sign-up
- Works on any device
Create a QR code for a link, Wi-Fi, WhatsApp, contact and more, or read one from a photo.
- Free
- No sign-up
- Works on any device
Fill in the details to see your QR code.
PNG for phones, chats and websites. SVG and PDF stay sharp at any size, which is best for printing. Tip: point your phone camera at the preview to test it.
3. Style (optional): colors, dots, logo
Choose a photo or screenshot or drag it here
Works with photos of printed codes, screenshots and image files.
Looking for QR codes…
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
- Pick serial to date or date to serial, and the date system of the workbook.
- Type the serial number, or choose the date and an optional time.
- Read the result and paste a list below to convert many values at once.
Why use this tool?
- Private: everything happens in your browser. Nothing you enter is uploaded.
- Free, with no sign-up, no watermark and no limit on how often you use it.
- Works on phones, tablets and computers: Android, iPhone, Windows, Mac and Linux. Nothing to install.
- Free to embed on your own website, with a ready-made code to copy.
- Available in 10 languages.
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.