Recover Date from Text to Column and Concatenate

Here is my Workbook Recoverdate4.xlsx with 3 desires

1. The formula in A3 to work (show date only and with or without time) for the raw data in B2 (there is a space at beginning that can't be avoided at present)
2. The raw data in B2 is Text to Column in B3 (fixed width) & B4 (delimit). The formula in A3 should account for this & show the date for either variation if possible.
3. Recover the date from the data being concatenate, examples A8 & A9

My Best Regards

Paul