JiminhoCopper ContributorAug 06, 2023Sorting 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 Show More
mathetesGold ContributorAug 06, 2023Jiminho 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))