I have a web extract of data in Excel that has a date column with /Date(1388624400000)/. I need to convert it to date in Excel.
Was able to deduce it from here.
Then use the formula =(C1/86400)+DATE(1970,1,1)
And for short, assuming the date is in A1:
=(Hex2Dec( MID(A1, 8, 10) ) / 86400) + DATE(1970, 1,1)