Convert Excel Date String to Date type

I have a date string with “Monday, February 02, 2007” format in a one cell column.

This is a .csv file exported to a excel file for some reason the column was changed to a string type instead a date type.

I need help in converting this date string to a date type of any format as long as it’s a date type not a string.