A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

If numbers keep changing to dates automatically in Excel or if Excel changes dates to random numbers then this post will help you fix the issue.