How to change date system for a workbook in Excel

Microsoft Excel allows users to change to 1904 date system (difference between 1900 and 904 date system) using the Excel Advanced Options. Listed below are the steps to change the date system in Excel 2016, 2013 and 2010

Step 1: Click the File menu then select Options link.

Step 2: In the Excel Options window, click Advanced tab.

Step 3: Scroll down to When Calculating this Workbook section.

Use 1904 date system for workbook in excel 2013 and excel 2010

Step 4: Mark the check box with label as Use 1904 date system.

Step 5: Click OK button available at the bottom of the window to confirm and save the changes.

Also See: Disable conversion of two numbers with hyphen as date in Excel

In Category: Excel 2010, Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 3 Comments
  • Sean Brady December 6, 2010, 5:21 am

    Cool. This really helped me understand a bit better than most posts!

  • Nora February 17, 2012, 8:37 pm

    Thank you! This was very helpful.

  • Daniel March 6, 2015, 11:55 pm

    stupid Macs do this all the time to spreadsheets.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.