I have an Excel document that has dates listed in cells as “January 1, 2020” where the month is written in English as a string value.
Question: Is there a way to parse this string into a Date type in the format “MM/dd/yyyy” without having to split the string and do any major manipulation? Preferably I am hoping something like the below would be possible.
EDIT: I have resolved my own issue, after some more digging, it turns out that these string formats can first be converted using
This returns a date in the format “MM/dd/yyyy” which was my ultimate goal!
Thank you all for the help!