When copying dates, they change by 4 yrs & 1 day, why?

[CAMiller]

When copying & pasting dates in a few of my worksheets, they change to one
day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.

Can anyone tell me what I am doing wrong?

Thank you,

 

[Teethless mama]

Copy > Paste Special > Values > OK

 

[Duke Carey]

Some of your Workbooks are set up to use the 1904 date system, others are
not, so they default to the 1901 date system.

You'll find the setting under Tools->Options. Not sure which tab for Excel
versions prior to 2007 (I've been upgraded to Excel 2007 - there it is under
Excel Options on the Advanced tab)

 

[Peo Sjoblom]

It's under tools>options>calculation in pre 2007 versions

 

[T. Valko]

It sounds like the source is set to use the 1904 date system.

Goto Tools>Options>Calculation tab>1904 date system

Uncheck that setting. Be careful though, this will change all the dates
already entered. This will add 4 years to your existing dates.

 

[J Cooper]

Hallelujah! Thanks for tip. Saved me hours!!!

It sounds like the source is set to use the 1904 date system.

Goto Tools>Options>Calculation tab>1904 date system

Uncheck that setting. Be careful though, this will change all the dates
already entered. This will add 4 years to your existing dates.