Jan 15 2021 12:48 PM
Does anyone know how to take a list of birthdays that are formatted for year and sort them by month and day? I've tried every permutation of reformatting and sorting in Excel and it always sorts by year, even after I format it with just the month and day appearing (for example, May-5). I want to send out birthday cards so I want to know which people have birthdays over the next week, for example.
Jan 15 2021 12:57 PM
SolutionLet's say the birth dates are in D2 and down.
In an empty column next to the data, enter MonthDay in row 1.
Enter the following formula in row 2:
=TEXT(D2,"mmdd")
Fill down.
Sort on the MonthDay column.
Jan 15 2021 01:44 PM
Jan 15 2021 12:57 PM
SolutionLet's say the birth dates are in D2 and down.
In an empty column next to the data, enter MonthDay in row 1.
Enter the following formula in row 2:
=TEXT(D2,"mmdd")
Fill down.
Sort on the MonthDay column.