Date in 2010 version

dennisli

Well-known Member
Joined
Feb 20, 2004
Messages
1,070
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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
 
Upvote 0
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:"
 
Upvote 0

Forum statistics

Threads
1,211,788
Messages
6,103,970
Members
447,888
Latest member
eaydogan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top