Excel dates column ascending automatically

[toddmaloney]

Have done a spreadsheet in Excel, and entered employees birthdays. Halfway through document the dates have changed and automatically ascending by year, however it skips a few dates. Does anyone know how to fix this as I originally entered their birthdays. Please help, I don't want to have to re-enter all dates again! Thanks in advance! :) 

[#2]

Make sure the dates are all entered in the dame format. For example YYYY-MM-dd.

Then select the column with dates and apply the date format that you wish to the entire column.

I hope this helps.