I have a column of dates from a MySQL database that are varchar. I need to be able to do a date range search on this column so I need to convert them to an excel date format but I haven't been able to find anything that really helps me. Right now the format is DD/MM/YYYY in Column C. I shouldn't have a problem doing the search, I just need a little help with getting them in the proper format. So to simplify my question: Convert a dd/mm/yyyy string to date ??

Thanks for any help.