date

[rooter]

Hi, I have two worksheets, let's call them #1 and #2, both have multiple
worksheets which are linked to other worksheets in the same workbook. I want
to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2.
All numbers get copied fine except for the date. So, for example, when I copy
the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all
the other dates. I've checked the formatting and all but can't figure why the
date would not copy exactly.

One thing that may be affecting this is that the two worksheets were
constructed on different computers...but dunno why that would make any
difference. I've even saved both files as "Macro-Enabled" but to no avail.

I'm stumped...would appreciate help. Thanks!

rooter

 

[Gary''s Student]

This can happen if the dates are the result of formulas and the cells being
referenced are not the same in both sheets.

Try this:
1. copy a cell
2. paste/special/value
3.paste/special formats

 

[rooter]

03Thanks! I tried that and it did not work. 12/31/2007 in sheet 1 Book 1
keeps showing up as 12/30/2003 in sheet 2 book 2. I copy as value and then
format. Its very strange and I'm not able to get around it.

 

[Gord Dibben]

If you go to Tools>Options>Calculation you will find at the bottom of dialog, a
checkbox for 1904 date system.

BTW..........it is 4 years and 1 day difference.

Add or subtract 1462 days to alter.


Gord Dibben MS Excel MVP

 

[rooter]

Thank you, David ad Gord...yes, one file was done on a Mac and the other on
PC. Its solved. Appreciate it.