For download and other information, see Using Date Migration Tools 2.0.

This wizard helps you find and fix date formats that use two-digit years. It also lets you change the century of dates where this is incorrect. You can use the wizard to create a report that identifies which workbooks contain dates and what are the earliest and latest dates in each workbook, so that you can determine whether dates have been interpreted as the wrong century.

The Date Fix Wizard works with dates that have been stored as numbers. Use the Date Migration Wizard to find and change text dates. For more information about text dates and using the Date Migration Wizard, click "How to Use the Date Migration Wizard" in the table of contents at the top of this article.

The wizard also helps you identify workbooks that have dates formatted in a secondary, non-Gregorian calendar.

Running the Date Fix Wizard

To find workbooks containing dates:

1. On the Tools menu, point to Date Migration, and then click Date Fix Wizard.
2. In step 2 of the wizard, click Scan for dates in a selected folder.
3. In step 3 of the wizard, select the workbooks to be scanned.
   To scan all workbooks in a folder, select All Microsoft Excel files in a specific folder, and then click Include subfolders if you want to scan subfolders.
   To scan your entire system, click Scan all local and mapped network drives.
4. In step 4, click Finish, and do not switch to another program until the wizard finishes creating its report.

To fix dates in a workbook:

1. Open the workbook in which you want to fix the dates.
2. On the Tools menu, point to Date Migration, and then click Date Fix Wizard.
3. In step 2 of the wizard, click Modify date values in a selected workbook.
4. In step 3 of the wizard, click the workbook you want to fix.
   To fix dates throughout the workbook, click Process entire workbook.
   To fix dates in a specific part of the workbook, click Process only the selected range, and then enter the sheet or range where you want to correct the dates.
5. In step 4 of the wizard, select how you want to modify the dates in the workbook.
   To change all dates to the 20th century, click Make all dates fall in the 20th century.
   To change all dates to the 21st century, click Make all dates fall in the 21st century.
   To fix dates with two-digit years, click Specify a cutoff year, and then click the number you want to use to determine the century for the dates.
6. Click Finish, and do not switch to another program until the wizard finishes creating its report.
   The report lists the original date value and new date value for each cell that the wizard changed.
7. To keep the changes, save the workbook that you modified.

To fix date formats in a workbook:

1. Open the workbook in which you want to fix the dates.
2. On the Tools menu, point to Date Migration, and then click Date Fix Wizard.
3. In step 2 of the wizard, click Modify date formats in a selected workbook.
4. In step 3 of the wizard, click the workbook you want to fix.
   To fix date formats throughout the workbook, click Process entire workbook.
   To fix date formats in a specific part of the workbook, click Process only the selected range, and then enter the sheet or range where you want to correct the formats.
5. In step 4 of the wizard, click Finish, and do not switch to another program until the wizard finishes creating its report.
   The report lists the original date format and new date format for each cell that the wizard changed.
6. To keep the changes, save the workbook that you modified.