Excel+Sorting+by+day+and+month+not+year

Excel Sorting by day and month not year

Sometimes you need to sort by the day and them the month and ignore the year

For example a list of birthdays.

If you allowed Excel to sort normally, it would do it by year which is not what you want when looking at birthdays of relatives and friends

How to correct this :‐

First you will need to have three (3) dummy columns that are designated

Day > Month > Year

You can hide these columns later by making them (0 or 1) width.

In column A 3 you have your date i.e. 05‐May‐98

In column B 3 on the same line You need the formulae:‐ =Day (A3)

In column C 3 You need the formulae:‐ =Month (A3)

And finally in D3 You need the formulae:‐ =Year (A3)

You then copy the formulas down each column

You can do this by dragging the small black square at the bottom right‐hand

Now you can sort by Day column as the first and Month column as the second and obviously the Year column as the last

By entering all the dates in the A column, B, C, and D are your working columns

Then this will give you a list that you require

Clever ?