Sort data by month and by dates

[Marcia]

How do I sort a column containing the birthdays of church members? My data column consists of birthdays of baptized members starting in 1910 and every Sunday all birthday celebrants during the week were read. I could only sort the birthdays by month and not by dates. When I perform the sort and filter commands, January 16, 1999 comes first before January 5, 2000. How do I sort so that January 5, 2000 appears before January 16, 1999?

[ArviLaanemets]

Add a column where you calculate the birthday for current year

=DATE(YEAR(TODAY()), MONTH(BirthDate), DAY(BirthDate))

or where you calculate date of next birthday

=DATE(YEAR(TODAY()) + (DATE(YEAR(TODAY()), MONTH(BirthDate), DAY(BirthDate))<TODAY()), MONTH(BirthDate), DAY(BirthDate))

and use the calculated column for sorting.

[Marcia]

I tried the suggested formulas above but I couldn't make them work, it says "you have entered too many arguments for this function =Year(Serial_Number)"

[ArviLaanemets]

Sorry, there was typo in both formulas (missing closing bracket for YEAR function). I corrected formulas in my previous post.

[Marcia]

Thank you ArviLaanemets, both formulas worked great.