With all due respect to Niek's response, may I beg to differ? Rather
than re-enter all the dates, you may be able to parse the text entries
into Excel-recognized dates using MID, RIGHT, LEFT functions in
conjunction with MONTH, DAY, and YEAR functions.