Pulling numbers from Text, then arranging as date

Hey y'all.. I am hoping that someone smarter than I, can assist with this.. I've tried several ways (text to columns, TEXTJOIN) unsuccessfully. I run Excel for Mac (Version 16.107 (26030819)).

It'd be great if the solution was dynamic, as I am continually adding to the Sheet.

I trade options (specifically SPX), and my brokerage provides me with .csv's containing my transactions. I'm creating a workbook that tracks my trades. Column E (formatting is General) is the "symbol", which has the following syntax:

-SPXW251010P6200 or -SPX251017P6150 (notice missing "W" in second example)

What I am trying to accomplish is to pull out the expiration date - "251010" and "251017" in the examples above, which are YYMMDD - for each record, and placing it in its own cell as DD/MM/YY (formatted as Date).

Any suggestions?? TIA