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
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Aug 06, 2023

    Jiminho 

    With 365, you could use this:

    =LET(dates, 1 * TEXTBEFORE(TEXTAFTER(Strings, "("), ")"), SORT(dates, , -1))
  • mathetes's avatar
    mathetes
    Silver 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