Extracting date range (Start and end dates) from text within a cell

[pcarignan]

Hi, each week I get about 2,000 invoices that I need to add a start and end date too. I'm looking for a formula that will automatically do this for 90-95% of my data set, and return "No Date" on the items I'll have to manually input

I've attached an example of the different types of text I get in Column A and my expected output in column C & Column D with comments describing some of my issues in Column E

[Bernie Deitrick]

You can use a VBA function to identify a lot of the dates, but some errors are not fixable - like the wrong year or leaving out a / that should appear between the month and day, or running dates together without spaces between....

[pcarignan]

You are amazing

[Bernie Deitrick]

Yes, I am . Now if I could just convince my wife of that fact...