I am using a
INDEX, MATCH function in sheet
Car Search to pull data from sheet
Raw Data. One of the cells is Date Purchased, this will show the date in format dd/mm/yyyy (UK Format).
The problem is, when I enter a date in this format, it doesn't correctly pull over to the
Car Search sheet. Instead, it shows up
42350 when I entered
12/12/2015 in the
Raw Data sheet. Both cells have been formatted to Date, but it is still showing up as 42350 and not 12/12/2015.
Is it because the function is preventing it from showing date format? Anybody know why Excel does this? I have tried on a new sheet, but same result.
Please see images below.