Extract date from string

I have been attempting to extract the date from a cell. I have tried using the MIN(), FIND(), RIGHT(), and LEFT() functions but have not been successful as my experience is limited with these functions. The premise is simple enough. Lets assume Column-A has alpha-numeric text strings. The strings will not always be the same length but will be composed the same.

A1= ".DIS210127C177.5"
A2 =".TSLA210502P500"
A3= ".SHOP210430C1020"

I would need the following to appear as dates:

B1= "01/27/2021"
B2= "05/02/2021"
B3= "04/30/2021"

I did receive help earlier on extracting other data from these cells....but now I can't seem to get this one to work.....any and all help would be HUGELY appreciated!!!!

Thank you in advance!!

Mike

One option

Formula:

Please Login or Register  to view this content.

OK....That worked PERFECT...but I will admit.....I have no idea how that worked.......!!!!!!!! Not even a little bit!!!!! Thank you so much!!!

You're welcome & thanks for the feedback.