Date Validation in Excel

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

Fixed Price

Delivery by April 25, 2013

$10.00

Budget

Details

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:
06/29/78

If the only the month and day are available the expected input in the cell next to it is:
MM/dd/1980

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 06:54 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