Excel dating system

06-Apr-2017 13:09

Excel hasn’t been around for 40,000 days, but Excel’s date system starts at January 1, 1900 (day 1), and today is day 40,000.

Not for Mac users though – its default date system starts at January 1, 1904 (day 0), so you won’t hit this milestone for another four years.

All versions of Excel for Windows calculate dates based on the 1900 date system.

Excel 2008 for Mac and earlier Excel for Mac versions calculate dates based on the 1904 date system.

excel dating system-15

If you are curious to know how Excel stores dates and times, please check out part 1 of this tutorial - Excel date format.

There are several ways to add dates in Excel depending on what exactly you want to do.

For example, do you want to enter a today's date in some report or invoice?

The two dating systems are explained in the Microsoft Knowledgebase article: Description of the differences between the 1900 date system and the 1904 date system in Excel.

Whether you’re using Excel on a Windows machine or on a Mac, you can switch from the default date system.

If you are curious to know how Excel stores dates and times, please check out part 1 of this tutorial - Excel date format.There are several ways to add dates in Excel depending on what exactly you want to do.For example, do you want to enter a today's date in some report or invoice?The two dating systems are explained in the Microsoft Knowledgebase article: Description of the differences between the 1900 date system and the 1904 date system in Excel.Whether you’re using Excel on a Windows machine or on a Mac, you can switch from the default date system.Excel date (09/07/00) to Julian formatted date (2000188)=YEAR(A1)&TEXT(A1-DATE(YEAR(A1),1,0),"000")4.