Forum Discussion
Convert extracted text into a date format for validation
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...
IMHO, it depends on regional settings. If DATEVALUE() works, with copy/pasting such text into Excel it shall recognize it as date.