Sort birthdays by month only in Excel - Full guide
Normally, dates in Excel are sorted first by year, then by month, and finally by day. However, sorting birthdays by month alone can be particularly helpful for managing and viewing birthdays more efficiently. This guide provides detailed steps and optimization tips to help you accomplish this task.
Sort birthdays by month only with helper column
The Excel’s Month function can help you to extract the month form the date, and then sort them by month and year quickly. Please do as follows:
1. In the adjacent blank cell of the dates, for example the Cell C1, enter the formula =Month (B2), and then drag this cell's AutoFill Handle down to the range as you need. And the months have been extracted from the birthdays. See screenshot:
2. Keep selecting these months, and click Data > Sort Smallest to Largest or Sort Largest to Smallest.
3. In the opening Sort Warning dialog box, please check the Expand the selection option, and click the Sort button.
And now the dates have been sorted by the month only at once. And you can delete the new column with month as you need.
Sorting birthdays by month and day only, while ignoring the year, here is another formula can help you: =TEXT(B2,"MMDD"). Use this formula to get the month and day only. And then, sort the dates as normal. See screenshots:
Sort birthday by month only with Kutools for Excel
Tired of using helper columns to sort your data in Excel? Look no further! With Kutools for Excel's Advanced Sort feature, you can effortlessly sort birthdays by month without the hassle of creating additional columns. Kutools for Excel can help you accomplish a variety of complex sorting tasks that are difficult to achieve with Excel's built-in features.
1. Select the list you want to sort the date by month and click Kutools Plus > Advanced Sort. See screenshot:
2. And then in the Advanced Sort dialog box, select the birthday column, and choose Month from the Sort On drop down list, then, choose the sort order, and click OK button. See screenshot:
And now you can see the birthdays have been sorted by month only. See screenshot:
Related Articles:
Sort cells by last character or number in Excel
Sort full names by last name in Excel
Auto sort column by value in Excel
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!