Date function- Help needed

Hi All,

I have two columns of dates. But among each column few are in date format and others are in general format. I am not able to make into a uniform format. I have tried =Text(col1,"mm-dd-yyyy"). But its not working on few rows. Kindly help me solve the problem..

I have attached the sheet also.Datefunctions.xlsx