Date Validation in Excel

Closed - This job posting has been filled and work has been completed.

Job Description

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:
"juin 29-1978\nOcc"

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.