Date Serial Number

Also known as · serial number · Dates

Excel stores a date as the count of days since 30 December 1899, so dates can be added, subtracted and compared; the date format only changes how it is displayed. A time of day is the fraction of a day. Also in Lec 03.

When to use

If a date cell shows a number such as 45641, nothing is broken: change the format to Date. Subtracting two dates gives days, 36526 is 1 January 2000, and date thresholds in filters and IF tests can be typed as serial numbers. A "date" that is left-aligned and will not calculate is text; convert it with DATEVALUE.

See Lec 04.

Appears in

No references yet.