I attached a spreadsheet of the problem column.
It contains text dates ('01/07/2017') and actual dates (January 7, 2017).
Goal - make entire column and values within it as dates
The problem is no matter what I try - the text doesn't convert and/or read as a date.
- I've tried left/mid/right permutations and the output reads '09/07/2917';
- DATEVALUE = #VALUE
- DATE = #VALUE
- convert entire column to values using "text to columns"
No luck.
Help is appreciated.
Thank you.
Bookmarks