Excel stores dates as sequential numbers and it is only a cell's formatting that causes a number to be displayed as a date, time, or date and time.

#### Dates in Excel

All dates are stored as

**integers**representing the number of days since January 1, 1900, which is stored as number 1, to December 31, 9999 stored as 2958465.
In this system:

- 2 is 2-Jan-1900
- 3 is 3-Jan-1900

#### Time in Excel

Times are stored in Excel as decimals, between .0 and .99999, that represent a proportion of the day where .0 is 00:00:00 and .99999 is 23:59:59.

For example:

- 0.25 is 06:00 AM
- 0.5 is 12:00 PM

#### Dates & Times in Excel

Excel stores dates and times as decimal numbers comprised of an integer representing the date and a decimal portion representing the time.

For example:

- 1.25 is January 1, 1900 6:00 AM
- 42005.5 is January 1, 2015 12:00 PM