Help Extracting first and second date from cell and date validation

[maximillianrg]

Hello Excel Masters

I need to audit and monitor 100's of status comments exported into Excel weekly and I'm looking for some help writing some formulas to that. Every cell will contain unique text and two dates. For this post lets use the following text in cells F1 and F2 as examples

Cell F1 = On 12-FEB-1809 Abraham Lincoln, the 16th President of the United States, was born in a one-room log cabin in Kentucky. On 14-APR-1865 Lincoln was assassinated at Ford's Theatre in Washington, D.C.just days after the end of the Civil War."

Cell F2 = It is predicted that on 13-April-25 parts of the Unites States will get more snow than the blizzard of 18-JAN-1988

---------------
Here are the 3 formulas I need help creating:

1. The formula in cell A1 extracts the first date it finds in cell F1 which is 12-FEB-1809. When filled down to cell A2 it returns the first date in F2 which is 13-April-25
2. The formula in cell B1 extracts the second date it finds in cell F1 which is 14-APR-1865. When filled down to cell A2 it returns the first date in F2 which is 18-JAN-1988
3. The formula in cell C1 examines the date in cell A1. If the date in A1 follows the dd-MMM-yyyy format it returns "Good" otherwise "Check" in the above C1="Good"
   • 12-FEB-1809 = Good
   • 12-Feb-1989 = Check
   • 12-FEB-89 = Check
   • 13-April-25 = Check
   • 13-APR-2025 = Good

Thank you for your help in advance on this