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?

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?

"iontrap" wrote:

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?

The two workbooks are using different date systems.

Go to TOOLS.OPTIONS and select the CALCULATIONS tab.
Make the USE 1904 DATE SYSTEM checkbox the same in both worksheets.
The default is that the box is not checked but you will have to decide based
on your particular situation.

B+
HALinNY

Thank you.
That worked.

"Roger Govier" wrote:

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?