Homework: Can you extract dates from text?

Homework: Can you extract dates from text?:
So who is up for a challenge? Can you use only formulas and extract dates buried inside text?

Your mission, if you choose to accept it,

1. Download this file.
2. In column C, write a formula such that you can extract the date in column B
3. If you succeed, post your solution here as a comment.
4. If you fail, drink some coffee, start afresh.

What are you waiting for? Start extracting!

Need some help?

If you want some clues, check out below links:

• Extract numbers from text using formulas
• Working with date & time in Excel – Basics
• Excel array formulas – examples & explanations
• More examples on date & time

Want more challenges? We got’em too

You better have access to lots of coffee or something strong, cause it going to get tough.

• Previous Excel Homework Assignments
• Excel Challenges

PS: If you feel like cheating, here is a solution.