Any suggestions on converting the example dates in the attached workbook to Excel dates?
I suspect the solution requires some utilization of SUBSTITUTE, REPLACE, and DATEVALUE, perhaps along with CONCAT and LEN, but my brain is fried and I can't manage to get a decent formula which works in all of the examples.
Thanks!
Bookmarks