Forum Discussion
doug-55
Jan 15, 2021Copper Contributor
Convert dates to birthday list
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 y...
- Jan 15, 2021
Let'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.
HansVogelaar
Jan 15, 2021MVP
Let'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.
- doug-55Jan 15, 2021Copper Contributor