Converting a text date: Thu, Aug 12, 2021 into real date
could anyone assist me with converting a text date column formatted like this: Thu, Aug 12, 2021 into a Date column?
For example, I have two columns.
- text date column where I am importing data in this format: Thu, Aug 12, 2021
- Real date column that forces a "real date"
I know I can use the =DATE(VALUE(LEFT([text date])@row .... VALUE(MID([text date])@row ...VALUE(RIGHT([textdate])
I am just having a hard time piecing it all together as I probably would have to also convert the months into actual numbers right right? Something like Jan = 01 , Aug=02 etc..
Thanks for any help!
Help Article Resources
Check out the Formula Handbook template!