Will adding 1462 to "1904" dates convert to "

Re: Will adding 1462 to "1904" dates convert to &a

Conradk said:

I need to merge two workbooks. One uses the 1904 date system and the other uses the 1900 system. Will adding 1462 to the 1904 system dates convert them to 1900 system dates?

Click to expand...

No, the best way to is convert the 1904 datevalues into text representation of dates (e.g., "12/4/1999") using the TEXT worksheet function (e.g., =TEXT(A1,"m/d/yyyy"), Copy/Paste Special... Values to preserve the TEXT function results, change date systems, then parse the text representations of dates (using the Data | Text to Columns... menu command) back into datevalues.

Thanks for the help.