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

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