Extracting a date from a text field
Ok, now... I have this data in one text column "2021-09-14 12:02:51" and I'm tryng to extract the date only (i.e. 2021-09-14) from this data and have it stored in a DATE column in the same sheet. I've tried many different ways but just can't make it work... I'm getting frustrated ;)
Help Article Resources
Check out the Formula Handbook template!