"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