Job to be completed in Excel. I will supply an Excel file with one column of text string data. Within the data is a date we require.
Sample data string in a cell:
Expected input in the cell next to it:
If the only the month and day are available the expected input in the cell next to it is:
If there is no distinguishable date, then leave it blank.
There are about 1000 lines of data.
Thank you for your interest.