You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
-
I think it's a Mac/Windows thing. There's a setting somewhere to switch between them (1904 date setting or similar).
-
Something to with this?
https://learn.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system
aggi
peter_h
@rhb
Odd one.
Workbook 1 has date 1/1/2022
Xlookup in Workbook 2 returns the date as 1/1/2026
I've checked formatting etc. Why else would date be offset by 4 years?
Edit1: Additional. If I copy cell in wb1 and paste it in wb2 the same happens. Am I looking at date serial code "zero" issue across the two workbooks? I inherited wb1 and created wb2.
Edit2: ^ yes. Both workbooks date value is 44774