Thread
:
Sorting by month, disregarding the year
View Single Post
#
3
Myrna Larson
Posts: n/a
Or, if you want to sort by month and DAY, make the formula
=MONTH(B2)*100+DAY(B2)
On Mon, 26 Sep 2005 09:01:18 +0100, "Bob Phillips"
wrote:
In a helper column, add a formula of
=MONTH(B2)
copy down, and sort by the helper column.
Reply With Quote