You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
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.
aggi
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