← All tools

Excel serial date converter

Convert Excel serial days and fractions using the 1900 or 1904 date system.

Your details

0 – 100000

Preparing your tool…

How it works

Interpret fractions as time of day. Reject fictitious serial day 60 in the 1900 system.

Example

1900-system serial 61 is 1900-03-01; 1904-system serial 0 is 1904-01-01.

What should I check before using the result?

Select the workbook system yourself. Values are treated as date/time fields, without a time zone.