Excel stores every date as a number.

Wacky WorldExcel & Office

In the default Windows date system, 1 January 1900 is day 1 and each day adds 1, so dates are just formatted numbers. That is why you can subtract two dates to get the days between them, and why a date turns into something like 45,000 when formatting is lost.

Another wacky fact → All facts