serial date number

Glossaries

Term	Definition
serial date number	Glossaries - Excel Terminology A serial date number is an integer that represents the date in the Excel calendar. By default, day 1 is January 1, 1900, through to 2,958,465 representing December 31, 9999. Storing dates using serial date numbers dramatically simplifies the calculation of durations and dates into the future and past as simple integer arithmetic. Number formatting takes care of displaying the numbers as a date for user readability. The actual numbers and date range may change based on the date setting in the workbook.. The date range supported, and the dates represented by each number is modified by the 1904 date system. Under the 1904 date system, day 0 represents January 1, 1904 through to 2,957,003 representing December 31, 9999. This option can be found and set in the Advanced Options by selecting: File » Options » Advanced » When calculating this workbook » Use 1904 date system. Changing this setting will move all the dates stored in the workbook backward or forward by 1462 days.

Term

Definition

Glossaries - Excel Terminology

A serial date number is an integer that represents the date in the Excel calendar. By default, day 1 is January 1, 1900, through to 2,958,465 representing December 31, 9999.

Storing dates using serial date numbers dramatically simplifies the calculation of durations and dates into the future and past as simple integer arithmetic. Number formatting takes care of displaying the numbers as a date for user readability.

The actual numbers and date range may change based on the date setting in the workbook..

The date range supported, and the dates represented by each number is modified by the 1904 date system. Under the 1904 date system, day 0 represents January 1, 1904 through to 2,957,003 representing December 31, 9999. This option can be found and set in the Advanced Options by selecting:
File » Options » Advanced » When calculating this workbook » Use 1904 date system. Changing this setting will move all the dates stored in the workbook backward or forward by 1462 days.