Forum Discussion
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
With 365, you could use this:
=LET(dates, 1 * TEXTBEFORE(TEXTAFTER(Strings, "("), ")"), SORT(dates, , -1))