Skip to content

Excel Serial Date Converter

Convert Excel serial dates in the 1900 or 1904 system to ISO UTC and back.

Convert in your browser · No sign-up

Rejects fictitious serial day 60 in the 1900 system. Fractions represent time of day; conversion rounds to milliseconds and assumes UTC.

Up to 100,000 UTF-16 units per input and 1,000,000 per result. See the supported formats and examples below.

Result

Add your input or load an example, then run the tool. Your result will appear here.

How to use

  1. Convert Excel serial dates in the 1900 or 1904 system to ISO UTC and back.
  2. Choose the mode or options, then run the tool.
  3. Review the result, then copy or download the TXT file.

Example

25569.5 (1900 system) ⇄ 1970-01-01T12:00:00.000Z

Details and limitations

Text stays in your browser; it is not sent to a conversion server.

Format references

Tool page updated: