How to sort date in Excel?

Question

excel

You need to sort the values ​​in the birthday column. Format of a cell date, sorting by means of the list on months did. But the date format is day.month.year
EXCEL FILE

Answer 1

In adjacent columns, add:
=Day(refer to your cell)
=Month(refer to your cell)
=Year(refer to your cell) Drag
the formulas down to the end of your data
Then turn on sorting: first month, then day...
In Excel 2010, the built-in sorting works without problems for me

Answer 2

If the cell format is a date, it should be easy to sort by itself.