Skip to content

Stockertim Dictionary · Technology

Date serial number

Also called date serial numbers, serial date, date serial, 1900 date system

In short

The number a spreadsheet stores behind a real date, counting days from a fixed starting date, which lets dates be sorted, subtracted and compared.

  • Intermediate
  • Concept
  • Checked

In detail

A spreadsheet does not store 1 March 2026 as text. It stores a whole number counting days from a starting point and displays it in whichever date format the cell uses. In Excel's default 1900 date system, 1 January 1900 is serial 1, so 1 January 2024 is 45292 and 1 March 2026 is 46082. Times are fractions of a day: midday is 0.5, and 6 pm is 0.75.

Because dates are numbers, arithmetic works on them directly. Subtracting one date from another gives the days between them, adding 30 gives a date 30 days later, and a comparison such as =A2<TODAY() flags overdue items. Functions such as DATE(year, month, day), EOMONTH and NETWORKDAYS build on the same serials.

Two quirks are worth knowing. For compatibility with older programs, the 1900 system treats 1900 as a leap year, so it contains a 29 February 1900 that never existed; this affects only dates before March 1900. Some workbooks, mostly older ones from Mac computers, use a 1904 date system that starts four years later, so the same serial means a date 1,462 days apart in the two systems. Copying dates between such workbooks shifts them by that amount.

The most common problem is a date that is not a serial at all but text, often from an export. Text dates usually sit at the left of the cell, ignore date formats, sort alphabetically and break subtraction. Day-month order adds risk: 03/04/2026 is 3 April in the UK and 4 March in the US.

Worked example

A law firm's office in Leeds checks how many days an invoice dated 1 March 2026 has been outstanding on 15 March 2026.

  1. 1 March 2026 is serial 46082 and 15 March 2026 is serial 46096
  2. Days outstanding: 46096 − 46082 = 14

Subtracting the two serial numbers gives 14 days.

In practice

Ageing reports, payment terms, project schedules and interest calculations rely on date serials. Data teams check imported date columns early, converting any text dates with DATEVALUE, DATE or Text to columns.

Watch out

  • A date that will not change format when the cell is reformatted is probably text.
  • Dates copied between 1900 and 1904 system workbooks shift by 1,462 days.

Learn it properly

Official sources

Facts last checked on 9 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English