This tutorial explains the procedure for grouping people based on month from the given date field in Excel 2013. Let us take the following sample data with students name and their date of birth.
Now to find out the list of students celebrating the birthdate grouped by months you can do the following
Step 1: Add another column next to the date column.
Step 2: For the first student, enter the formula for the new column as =MONTH(B4), where B4 is the date birth for the first student.
Step 3: Now use the Excel auto fill feature to copy the formulas for the other students to find out month from their date of birth.
Step 4: Select all the three columns, navigate to Editing section on Home menu and click Sort & Filter option and select Custom Sort from the menu list.
Step 5: In the Sort window, choose Column C for Sort by drop down, Values for Sort On drop down and Smallest to Largest for the Order. Now click Ok button to group the students based on the month of their birthdate.
You can further simplify this by using excel filters to pick only specified month using the filter criteria on the month column.