Copying or moving a sheet to a new workbook is a simple task, usually. But, suppose a simple copy task ends with a call to you for help because the new workbook shifts each date value by four years and a day! For instance, the new workbook converts the original date 5/2/2012 to 5/1/2008. What’s happening and can you find a happy ending for this user?
Office challenge: Why does Excel change dates when I copy a sheet to a new workbook?
Takeaway: This week, test your Excel skills by identifying and remedying this troublesome date behavior.
Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.
No messages found
Agreed with Tron16
The Deeper Question
Changing calculation creates more problems
That's because Feb 29, 1900 does not exist...
so to find the previous leap year on a new century you have to go
back to 1600. There is a leap year every year whose number is perfectly divisible by four - except for years which are both divisible by 100 and not divisible by 400. The second part of the rule effects century years. For example; the century years 1600 and 2000 are leap years, but the century years 1700, 1800, and 1900 are not. This means that three times out of every four hundred years there are eight years between leap years.
There are no posts from your contacts.
Adding contacts is simple. Just mouse over any member's photo or click any member's name then click the "Follow" button. You can easily manage your contacts within your account contacts page.