You are reading a single comment by @peter_h and its replies.
Click here to read the full conversation.
-
Something to with this?
https://learn.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system
Something to with this?
https://learn.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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