Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Matching Dates (Excel 2000)

    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.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Matching Dates (Excel 2000)

    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.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •