I have an IFTTT integration that writes date strings to a sheet. I'm trying to filter the sheet by days of the week, but in order to do that, I need to be able to convert the date strings into actual dates.
The dates are formatted like this:
August 12, 2019 at 08:40PM
But when I feed it into DATEVALUE, it cannot parse it. I've tried removing the leading 0 before 08:40PM and adding a space between the minute and PM, but no luck.
Aucun commentaire:
Enregistrer un commentaire