Hi

Go to ToolsOptionsCalculation and untick the 1904 Date option.

--
Regards

Roger Govier


"iontrap" wrote in message
...
I am copying dates from one workbook to another. Everytime I copy a
date into
the new workbook, the date is incorrect: 10/12/2005 becomes 10/11/2001
and
1/18/2006 becomes 1/17/2002. This is the first time I have run into
this
problem, is there a solution?