How to sort birthdays using the MONTH and DAY functions in Excel
Today, we will be using both the MONTH and DAY Functions to sort a list of birthdays by month. We need to do this because this is not possible using Excel’s usual sort function. We will be using an additional column to convert the month and day dates to serial values so that we can sort them. Here is how we’ll do this:
How to sort dates by month using the MONTH and DAY Function
- Enter the names in Column A and the birthdays in Column B.
- Select cell C1 and type the following formula: =MONTH(B1)*100+DAY(B1).
- Use the fill handle to copy the formula as needed.
- Select cell C1. From the Standard toolbar, click Sort Ascending.
- Format the column as General to display serial values rather than dates.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- Use the EOMONTH function to determine the last day of a month
- Use the LEFT, MID, and RIGHT functions to extract date parts
- How to Use the ISODD and ROW functions to determine odd rows
- Use the ISEVEN and ISODD functions to check if a number is even or odd
- Use the ISODD and COLUMN functions to determine odd columns
