Sorting DATE data

Copper Contributor

I have some date data that i wish to convert so i can sort it latest to oldest.

It's in text format.


Can anyone help?





2 Replies



So long as those dates at the end of the text string are consistent (12 characters in length), this formula works to convert to standard Excel serial number dates which are readily formatted as "Short" or "Long Date"







With 365, you could use this:

=LET(dates, 1 * TEXTBEFORE(TEXTAFTER(Strings, "("), ")"), SORT(dates, , -1))