Excel Guides

Changing Excels Starting Date

Excel's starting date is the date that is used for reference when working with dates in the program. This date can be changed to better suit your needs. In order to change Excel's starting date, follow these steps:

  1. Open Excel and click on the 'File' tab in the top left corner.
  2. Click on 'Options' in the drop-down menu.
  3. In the 'Excel Options' window that appears, click on 'Advanced' in the left sidebar.
  4. Scroll down to the 'When calculating this workbook, use this start date:' option and select the desired start date from the drop-down menu.
  5. Click 'OK' to save your changes and close the 'Excel Options' window.

That's all there is to it! Now when you work with dates in Excel, they will be based on the start date that you selected. This can be helpful if you're working with data from a different country or time period and need to ensure that your dates are accurate.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.