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...
SergeiBaklan , Thank you. I got #VALUE! error with this formula
So, I tried power query and it resolved the issue.
Here it is
Perhaps in your case text has some other non-printable characters.
Power Query is good enough, the only it puts result into another place. Again, Text to Columns could work if to transform in place.