MrExcel Publishing
Your One Stop for Excel Tips & Solutions

copy dates

Posted by Jon Wells on February 04, 2002 1:01 PM

I am trying to copy part of a spreed sheet that in cludes dates. When I copy them into a new workbook the dates change. Examples are 3/15/02 when copied changes to 3/14/98. I am using the copy command.
Thank you in Advance

Jon Wells

Posted by Yogi Anand on February 04, 2002 1:41 PM

Hi Joe:
It looks like some body has put a hex on your computer ... kidding aside, I can think of two possibilities

the source area (from where the copy has been made, is a formula involving the date function using the year, month, and day as parameters, or using the today() function, which gives the current system date as the system knows it -- so
1) in the copied to location, there may be different parameters resulting in a different date at the copied to location;
2) the system date in the source system and the copied to system may be different, thus resulting in different date displays,
and of course among other things, it can also be a combination of both of the things mentioned above.


Yogi Anand
ANAND Enterprises (broken link)