If you go to ToolsOptionsCalculation 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

On Fri, 16 May 2008 08:41:01 -0700, rooter
wrote:

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