Adding One Day to Date When Copying Date to Another Excel Worksheet

[chcalissie]

I'm copying dates from one Excel file to another. Both are in Excels are in the same version of Excel - 2007. When I copy the date to the other file, one day is added. For example, 12/4/2014 becomes 12/5/2014. Why is this happening? How do I correct it? Thanks for any help.

[ChemistB]

Is it a simple copy and paste of a number (aka date) or is it of a formula? Do either of the sheets have macros?
When you click on the two cells (old and new), what do you see in the formula bar (white long text box above the columns)?

[chcalissie]

It's just a copy and a paste from one file to another. Both are set as date fields. There's a dropdown arrow in the heading for the date column, but in the formula bar they both show mm/d/yyyy (e.g., 12/4/2014). I check the value of the date field from which I'm coping by looking at it as if it were a General field and it showed the value (e.g., 41977 for 12/4/2014). In the cell into which I'm copying the number it shows as 12/5/2014. I think I've run into this before, but I thought it was because the files were different versions of Excel. That's not the case this time.

Actually, it's adding years, too. 12/4/2014 become 12/5/2018. But when I put them both in general format, they show 41977. When I enter 12/4/14 and reformat to general, it shows 40515. This is getting stranger.

[shg]

The first workbook is using the 1900 date system, the second is using the 1904 system. Change the latter.

[romperstomper]

Check the Advanced options and make sure the target sheet isn't set to use the 1904 date system.

[chcalissie]

That was it!! Thanks.

[FlameRetired]

The first workbook is using the 1900 date system, the second is using the 1904 system. Change the latter.

Great catch, shg! Something else to stay alert for.....