Sort by Month then by Day (ignore year when sorting)

You could consider adding a sort column that calculates the fraction of a year from the beginning of the year and sort on that, hiding the column if you want after you've set it up:

In D2, filled down:

=YEARFRAC(DATE(YEAR(B2),1,1),B2)

More on YEARFRAC here:

YEARFRAC - Apple Support

SG

Hi Joke,

sorry but Numbers is sorting correctly.

1-24 is smaller that 1-6!

The first 2 digits are identical and in the 3rd digit the 2 is smaller than the 6, therefore the sorting is done correctly.

It will sort the 1st digit first, then the 2nd digit and so on.

Here a solution for your task

Formula for C2=CONCAT(IF(MONTH(B2)≤9,0,""),MONTH(B2),"-",IF(DAY(B2)≤9,0,""),DAY(B2))

The IF function will add a 0 as soon as the month / day is only one digit.

Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Regards Ralf

Your "day of year" column could also be created as =DATE(1,MONTH(B),DAY(B)) with the cell formatted to show only the month and day. This formula makes all of them have the same year so they will sort as you wish. Any year will work, I chose year 0001.

sorted: