Date column with different text and string values

[abhishekyx]

How to convert the date column to standard format and extract date from text value.

attachment for reference.

[Raj]

@abhishekyx 
please add the expected output

will be in better position to help.