Forum Discussion
Solved
Need help in extracting the latest date from a cell
Hello Everyone, Last 7 Days (9/1/22-9/7/22) Need help in extracting the latest date from the above string in a cell.
Let's say the text is in cell A1.
Enter the following formula in another cell:
=DATEVALUE(MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)-1))
Format the cell with the formula as a date.
Let's say the text is in cell A1.
Enter the following formula in another cell:
=DATEVALUE(MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)-1))
Format the cell with the formula as a date.