Sorting DATE data

[Jiminho]

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?

Thanks

[#2]

@Jiminho 

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"

=VALUE(MID(A1,FIND("(",A1)+1,12))

[#3]

@Jiminho 

With 365, you could use this:

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