Use the MONTH and DAY functions to sort birthdays by month - Date and Time Functions - Microsoft Excel Tutorials

Use the MONTH and DAY functions to sort birthdays by month using Microsoft Excel

The worksheet in Figure 4-14 contains a list of employees and their birthdays. This list has to be sorted by month, which is not possible with Excel’s usual sort function. Use this tip to insert a supporting column to convert the month and day dates to serial values.

To sort birthdays by month:

1. In cells A2:B10 generate a list of employees and their birthdays.
2. Select cells C2:C10 and type the following formula:
=MONTH(B2)*100+DAY(B2).
3. Press <-Ctrl+Enter->.
4. Select cell C1.
5. From the Standard toolbar, click Sort Ascending.
6. Format the column as General to display serial values rather than dates.

Use the MONTH and DAY functions to sort birthdays by month

Watch the Video Tutorial - https://www.youtube.com/watch?v=g9bFI1gEzOs