1. Home
  2. Rebasing Dates

Rebasing Dates

You can change the base date for a date column to one of the following:

1/3/1600 The nominal starting day for the Gregorian calendar.
1/1/1900 The starting day used by spreadsheets such as Excel, Lotus and Quattro.
  1. Put the cursor in the spreadsheet column you want to change then select Spread | Calculate | Rebase Dates.
  2. When the warning prompt appears click Yes.
Updated on December 14, 2018

Was this article helpful?