How do I sort dates by month in Excel, regardless of the year?

Question

I have a spreadsheet that lists all of my workers' birthdays. I want to sort the dates by month, so that I can easily view the birthdays for this month and set up a greeting card to go out.

Regardless of how I format the dates - short date, long date, etc., it does not allow me to sort by month. The options given are oldest to newest (or vice versa) and month order -- January, February, March, etc. When I select month order, nothing happens. It still keeps everything in complete date order.

Answer 1

Let's say the birth dates are in D2 and down.

In another column, enter the following formula in row 2, then fill down to the last used row.

=TEXT(D2, "mmdd")

You can sort on this new column.

Answer 2

That worked! Thank you so much for the prompt response.

Answer 3

Hi,

You may go to a specific month via the filter. In the Filter drop down, go to All dates in the period and select any month.