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?

Add a column where you calculate the birthday for current year
or where you calculate date of next birthday
and use the calculated column for sorting.

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)"

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

Thank you ArviLaanemets, both formulas worked great.