There’s column A that I’d like to convert to a datetime object. I tried with custom formatting but I got no results. I also tried to change the locale to the one I’m currently located and then the custom format but still didn’t get anywhere.
The final results I’d like is a column with YYYY-MM-DD.
Example sheet
>Solution :
Try this formula in row 2 of an empty column :
=ARRAYFORMULA(TEXT(SUBSTITUTE(A2:A10,"at",),"YYYY-MM-DD"))