Copy & Pate between workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-3086245%22%20slang%3D%22en-US%22%3ECopy%20%26amp%3B%20Pate%20between%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086245%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20copying%20a%20date%20from%20one%20workbook%20to%20another.%3C%2FP%3E%3CP%3EThe%20date%20located%20in%20the%201st%20workbook%20is%20%2203%2F02%2F08%22%3C%2FP%3E%3CP%3EThe%20result%20when%20I%20paste%20it%20into%20the%20other%20workbook%20is%20%2203%2F01%2F04%22%3C%2FP%3E%3CP%3EI%20tried%20converting%20the%20dates%20to%20text%20%26amp%3B%20to%20number%20%26amp%3B%20then%20reformatting%20back%20to%20dates.%3C%2FP%3E%3CP%3EBoth%20locations%20show%20the%20reformatted%20dates%20with%20the%20same%20text%20or%20number.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3086245%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3086442%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20%26amp%3B%20Pate%20between%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086442%22%20slang%3D%22en-US%22%3EThis%20means%20that%20one%20of%20the%20workbooks%20uses%20the%201904%20date%20system%20(default%20on%20Mac)%20and%20the%20other%20doesn't%20(default%20on%20Windows).%20Add%201460%20to%20the%20date%20in%20the%20target%20workbook.%3C%2FLINGO-BODY%3E
New Contributor

I am copying a date from one workbook to another.

The date located in the 1st workbook is "03/02/08"

The result when I paste it into the other workbook is "03/01/04"

I tried converting the dates to text & to number & then reformatting back to dates.

Both locations show the reformatted dates with the same text or number. 

2 Replies
This means that one of the workbooks uses the 1904 date system (default on Mac) and the other doesn't (default on Windows). Add 1460 to the date in the target workbook.
Yes, I just found out a bit ago. I set cells to transfer back & forth between the 2 workbooks. When I transferred no date, the other workbook showed 1/1/1904. Changing the 1904 option fixed the problem. The only thing is, both workbooks are Excel 365 and I didn't touch the date setting option in either one. Must be MS goblins at work again. THANS FOR THE REPLY!