I have extracted a value into a cell from a text field in an external system and the value extracted is "20-Sep-2023"
If I write a formula in excel, to compare this date against today(), it does not work because it treats this value("20-Sep-2023") as a text field
Can you please suggest, how should I convert the extracted text("20-Sep-2023") into a date so that, it can work in formulas.
Bookmarks