Dates change when copying...

Solved/Closed
NgangaKP
Posts
1
Registration date
Monday March 18, 2013
Status
Member
Last seen
March 18, 2013
- Mar 18, 2013 at 07:19 AM
 NgangaKP - Mar 23, 2013 at 01:12 PM
Hello,

Thanks to this kind of forum, I've been able to deal with issues around the date systems 1900 vs 1904. It remains a problem though since I very often exchange files with correspondents in Congo who use PCs and Excel Microsoft.
But even more strange: when I copy a set of rows containing dates from one workbook to another (on my computer), the system adds two days!!? Why is that, en how can I prevent that?

2 replies

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 18, 2013 at 03:17 PM
Hi NgangaKP,

As you mentioned you have already check the "Date System" (1900/1904) of the source and target workbook and they are same, try to paste the dates as "Value" from the source workbook to the target workbook and check if it works.

Do reply with results.
0
Yes it works. Thanks, Zohaib R, and sorry for waiting so long before reacting. I had a lot of workbooks to check and correct.
0