Will adding 1462 to "1904" dates convert to "

Conradk · Apr 21st, 2003, 10:57 PM

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?

Mark W. · Apr 21st, 2003, 11:02 PM

Quote:

Originally Posted by Conradk

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?

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.

Conradk · Apr 22nd, 2003, 03:45 PM

Thanks for the help.

Apr 21st, 2003, 10:57 PM	#1
Conradk Join Date: Apr 2003 Location: Winston-Salem Posts: 38	Will adding 1462 to "1904" dates convert to " 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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2003, 03:45 PM	#3
Conradk Join Date: Apr 2003 Location: Winston-Salem Posts: 38	Thanks for the help.