Use the MONTH and DAY functions to sort birthdays by month using Microsoft Excel
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.
Watch the Video Tutorial - https://www.youtube.com/watch?v=g9bFI1gEzOs
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 |
No comments:
Post a Comment