Date Validation in Excel

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Other - Accounting & Consulting Posted 3 years ago

Fixed Price

Budget: $10
Delivery by April 25, 2013

Start Date

April 24, 2013


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.

About the Client

(5.00) 7 reviews

United States
Champlain 01:28 PM

9 Jobs Posted
67% Hire Rate, 1 Open Job

$565 Total Spent
10 Hires, 2 Active

$9.58/hr Avg Hourly Rate Paid
48 Hours

Member Since Jun 17, 2008