Nice Domski. I didn't even think to coerce excel into converting it like that with the *1. I was going to provide a longer more complicated version that it didn't need to be.

=DATE(20&RIGHT($B2,2),MONTH(1& LEFT($B2,FIND("'",$B2)-1)),22)

So that helped me too and I didnt need it