Sort by Date of Birth

[Anonymous]

Dear all,

I have a table like below:

I want to sort the above table by "Date of Birth" (without considering the year).

i.e. after sorting, my output should look like below.

How can I do this? Please help.

Thank You!

[Anonymous · Accepted solution]

Create a custom column and use the formula

Birthday = FORMAT([Date of Birth], "MM-DD")

Now sort on the Birthday column

[Anonymous]

Thank you both of you!

[dearwatson]

So it looks like you are sorting by month number in year is that correct?

To achieve this you will need a column to faciliate the sort.

in this case create a column

Month Num = MONTH(Table1[Date of Birth])

then select the "date of birth" column and use the "Sort By Column" button to select "Month Num" this will sort the months in the correct order as per your screen shot.