Forum Discussion

Jiminho's avatar
Jiminho
Copper Contributor
Aug 06, 2023

Sorting DATE data

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  
excel
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Aug 06, 2023

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))

 

 

 

Resources