How to sort dates in Excel by month
Do you know how to sort a list of employee birthdays by month?
If you simply sort the dates, they will be ordered by year, not month.
The MONTH function in Excel will help us with this task. It extracts the month number from the date in a cell.
Let's apply this function to the birthdays in the helper column, and then sort the table by it. Great, a correct list of employee birthdays is ready.
⚠️ We teach you how to work in Excel from scratch in our online courses. All the details are available at: https://excelhack.ru/kursy 👈