I have a text column with a value like this: Tue, July 3rd 2018
I want to convert it to a Date column. My formula looks like this:
DATEVALUE(@[email protected] ,"E, MMM d'th' yyyy")
How do I make the formula handle not only 'th' but also 'nd', 'rd', and 'st'?