Matching Dates (Excel 2000)

Topic

New Reply

I’ve got a lot of data entered from several years ago. Many of the variables are dates. Recently I created a new data set, now I need to combine the two sets.
Dataset1 was originally created using the 1904 date system. Dataset2 was created using the 1900 date system. When I put them in the same worksheet, either one set or the other ends up with the wrong dates.

I can’t figure out a way to combine them without rewriting all of the dates in 3 columns as MDY, then I could put them back together in the new worksheet. If anyone can suggest something easier, I’d be grateful.

Reply | Quote

Replies

If you want to convert both of them to the 1900 date system, then open the workbook that is using the 1904 date system. Go to Tools/Options, click on the Calculation tab and unselect the 1904 date system. All of the dates should now be incorrect. Find an empty cell somewhere on the sheet and enter the value 1462 into that cell. Select that cell and then select Copy from the Edit menu. Now, select all of the cells that contain dates and select Paste Special from the Edit menu. In the Operation section of the dialog box select Add and then click on OK. Format the cells back to the proper Date format while they are still selected, and they should now display the correct date in the 1900 date system and you should be able to combine the two workbooks.

Reply | Quote