Finding a date in a text string and comparing it to a date range

We are required to update our active records every 10 days with status notes. The date is entered at the beginning of the note. There is not a consistent format for the dates.

I’m looking for is a way to check the date at the beginning of each txt string. I want to see if it falls within the range of today() and today()-10. Anything older than 10 days, I want a “Y” and within the 10 days range, blank.

Listed below are a few note examples. The first 3 notes are past due.

Text String 1: 10/26- example data 1
Text String 2: 10/26/12 example data 2
Text String 3: 10/26/12 example data 3
Text String 4: 10/29 example data 4
Text String 5: 10/29 - example data 5

Post an Excel example without confidentional information, and with the desired result.

I bet you get better result if you post it.