Skip to content

How do spreadsheet serial dates work?

Spreadsheet serial numbers and calendar dates, in the 1900 or 1904 system.

Convert

Date system

Result

46326.5

Saturday, 31 October 2026, 12:00:00

The other date system

1904 system
44864.5

Spreadsheet serial numbers and calendar dates, in the 1900 or 1904 system.

How to use

  1. Choose a conversion direction and spreadsheet date system.
  2. Enter a serial number or a Gregorian date and time.
  3. Read the result and check whether the 1900 leap-year bug applies.

How it works

Spreadsheet dates are numbers: the integer part counts days and the fraction counts time within the day. A fraction of 0.5 means noon. No time zone is attached to a spreadsheet serial.

In the 1900 system, serial 1 is 1900-01-01. Excel deliberately preserves the old compatibility bug that treats 1900 as a leap year: serial 60 is the nonexistent 1900-02-29. In the 1904 system, serial 0 is 1904-01-01. Microsoft documents the 1462-day difference between systems for modern dates.

Serial 61 in the 1900 system is 1900-03-01. The converter identifies serial 60 instead of silently turning it into a real date. Date input must be real; it cannot enter the fictional day. Fractions are displayed to the nearest second, capped at the last second of the serial day.

Worked example

The 1900 boundary

  1. 59 → 1900-02-28; 60 → fictional 1900-02-29; 61 → 1900-03-01.

Default input → 46326.5.

Frequently asked questions

What does serial 60 mean?

In the 1900 system it is the fictional 1900-02-29, retained for compatibility.

Why do two workbooks differ by 1462 days?

They may use different date systems: 1900 and 1904.

What does the fraction mean?

It is a fraction of 24 hours: 0.5 is 12:00:00.

Does a serial include a time zone?

No. UTC is used here as a neutral clock label; no time-zone shift is applied.

Can I enter 1900-02-29 as a date?

No. It is not a real Gregorian date. Enter serial 60 to inspect the spreadsheet bug.

Send feedback