Error when copying dates

S

sjc

I am copying dates from one spreadsheet to another, however, the wrong date
shows up in the destination worksheet. For example, the source worksheet has
05/29/2007. When this cell is copied to the destination, it shows up as
05/28/2003. This error occurs regardless of the date used. The source
worksheet is in compatibility mode and the destination worksheet is Excel
2007.
 
Top