Forum Discussion
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 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.
svaydtla not sure what exactly you want but in the attached I created 2 total columns. 1 for all unique Gender and 1 for all unique Origins and then countif for each. But the easier way that also give a full table of every combination is to do a pivot table of this information. Also in the attached and done using these steps:
a) highlighted those 2 columns
b) selected Insert pivot table and selected cell where to put it
c) dragged gender and origin to rows and columns boxes and then origin (or gender) to the Values box
d) right click on pivot table and selected Pivot Table Options and clicked tab for totals and selected to show Grand totals for rows and columns
2 Replies
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.
