"nitsa" wrote in message
...
When I copy a date from one file into another, the date value changes. for
example when I copy 4/1/2006 and paste it into another sheet, I get
3/1/2002.

Your first file is using the 1904 date system, the other isn't.

Tools/ Options/ Calculation.
--
David Biddulph