Or you could just do Find & Replace in Excel so that they all have the same format, and then use Text to Columns in the Data menu to convert the pieces to three separate columns.
Alternatively, you could use string and format functions to parse the date out into pieces. Then you could either create separate columns, or just enter them in YYYYMMDD format, which Excel will read as an integer and sort correctly.