Is there a way to sort dates on month and day and ignore year?

[JenniferMurphy]

Is there way to sort a column of dates on just the month and day, ignoring the year? This is the only way I could think of by adding a helper column.

Family Database.xlsx
	B	C	D
3	DoB	Age	mm/dd
4	2/03/1944	79.0	0203
5	2/14/1999	24.0	0214
6	2/25/1963	60.0	0225
7	4/06/1968	54.9	0406
8	6/19/1997	25.7	0619
9	7/06/1949	73.6	0706
10	8/30/1968	54.5	0830
11	11/13/1951	71.3	1113
12	11/15/2005	17.2	1115
13	12/08/2007	15.2	1208
14	12/13/1945	77.2	1213
15	12/19/1966	56.2	1219
MrExcel-02

Cell Formulas
Range	Formula
C4:C15	C4	=IF( IsADate([@DoB]),CONVERT(TODAY()-[@DoB],"day","yr"),"")
D4:D15	D4	=TEXT([@DoB],"mm") & TEXT([@DoB],"dd")

Named Ranges
Name	Refers To	Cells
'MrExcel-02'!DoBBurke	='MrExcel-02'!$B$14	C14:D14
'MrExcel-02'!DoBWes	='MrExcel-02'!$B$4	C4:D4

 

[aRandomHelper]

I think a helper column should be the best way to do what you want; also, you can shorten the formula to:

=TEXT([@DoB],"mmdd")

 

[Georgiboy]

You could use the SORTBY function but that will mean having a seperate sorted range:

=SORTBY(A2:C13,MONTH(A2:A13),1,DAY(A2:A13),1)

 

[bebo021999]

Beside VBA, I think helper columns is the only solution to sort.
Alternative formula in D4:
=MONTH(B4)*100+DAY(B4)
With VBA, no helper column needed.

 

[JenniferMurphy]

I think a helper column should be the best way to do what you want; also, you can shorten the formula to:

=TEXT([@DoB],"mmdd")

Great, thanks. This is better.

 

[JenniferMurphy]

You could use the SORTBY function but that will mean having a seperate sorted range:

=SORTBY(A2:C13,MONTH(A2:A13),1,DAY(A2:A13),1)

I didn't know about that function. Thanks

 

[JenniferMurphy]

Beside VBA, I think helper columns is the only solution to sort.
Alternative formula in D4:
=MONTH(B4)*100+DAY(B4)
With VBA, no helper column needed.

I like that formula. It has the advantage ofr returning a number, not text.

Since I have a simple solution, I probably wouldn't resort to VBA. But just out of curiosaity, how would a VBA solution work?

Thanks

 

[aRandomHelper]

But just out of curiosaity, how would a VBA solution work?

You wouldn't need column D, and on a click of a button (or whichever way the macro is triggered to run), columns B and C (including any other defined range/column) can be automatically sorted according to your criteria.