=TEXT(MID(A1,7,8),0000-00-00)