Date in 2010 version

[dennisli]

Good afternoon,
In Excel 2010 version, I have a date ( December 31, 2011) in one file. When I copy this date to another book, it changes to December 30, 2007.
Any ideas?
Thanks

 

[Jonmo1]

One of the books (I think the first one) is using the 1904 Date system.
Not sure where that setting is in 2010, I'm using 2003 right now.
But it should be in the same place you turn calculation on/off

 

[Jeff Meyers]

Try this:

File - Options - Advanced
and then be sure to uncheck / deselect "Use 1904 date system"
This option is near the bottom in the section: "When calculating this workbook:"

 

[dennisli]

thanks lot. have a good day.

 

[Jeff Meyers]

You are welcome. Thank you for the feedback.