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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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)
 
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.
 
Hallelujah! Thanks for tip. Saved me hours!!!

T. Valko said:
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.
Click to expand...
 
Back
Top