Nice article. Thanks
I would outright refuse to use data in a column that seems to be date data but has no consistent formatting. The problem is that you don't know whether some cells are dmy or mdy and even worse if the year is 2 digit and the data is from 2001 to 2012!
Totally agree that Try_Convert and Try_Cast tend to be the best functions to use for these sorts of conversions.