Hi, I think my issue is just a date formatting issue but please correct me if you see something else. I have data going into a pivot table on one tab and then that data is being pulled into another tab via a Xlookup. My formula is using the date to match the two references between the two...