[Solved] Data>Sort: Need it by month without regard to year

[HeidiD]

Hello,
I have a set of data that I'd like to sort by Month, without regard to year. Office only seems to sort by year, ascending or descending, even though I've gone into the Options tab and checked Custom Sort Order and changed that to months. Is it possible to sort by month without regard to year?
Thanks

[Zizi64]

Use a helper column with the function =Month(), then sort the range based on the helper column.

[HeidiD]

So you're telling me to go through all 50 lines of data, add a column, type the month from Column B into the new column and then sort?

[RoryOF]

In the first cell of the helper column enter =Month(Address of date column) or whatever the correct syntax is, select that cell, and pull down by the black dot in bottom right corner.

[Zizi64]

test data set2.ods

(14.58 KiB) Downloaded 122 times

The range was sorted based on the column D

[Villeroy]

Do you need the next birthday or something?
=DATE((DATE(YEAR(TODAY());MONTH(B1);DAY(B1))<TODAY())+YEAR(TODAY());MONTH(B1);DAY(B1))

the blue part compares this year's B1 date with today's date and returns 1 if it is smaller than today (this year's birthday is today or happened already) or 0 otherwise (this year's birthday is to come). This 0 or 1 is added to the year of this year's B1 date.