I'm opening a csv report in Google Sheets. The Google Drive preview shows the dates like this:
When I open this file in Google Sheets the dates now look like this:
And if I try and convert the date to int and then date it works for some but not all:
Any idea how I can extract just the date from these cells?