How to sort dates by Month/Day and ignore year.

[Eloise T]

Need formula to sort dates in Column B by Month/Day and ignore Year in the attached file. Thanks.

 

[Chihiro]

Since Col B has actual date value, use formula below in Col C.
=TEXT(B2,"MMDD")

Then select both columns and Sort, Values, A to Z.

In the pop-up select "Sort numbers and numbers stored as text separately" to have "?" appear at top of the list, the other option will put it at the bottom of the list.

 

[PaulF]

C2 =IFERROR(MONTH(B2)*100+DAY(B2),"")
Drag down...

 

[Eloise T]

Since Col B has actual date value, use formula below in Col C.
=TEXT(B2,"MMDD")

Then select both columns and Sort, Values, A to Z.

In the pop-up select "Sort numbers and numbers stored as text separately" to have "?" appear at top of the list, the other option will put it at the bottom of the list.

Thanks!

 

[Eloise T]

C2 =IFERROR(MONTH(B2)*100+DAY(B2),"")
Drag down...

Thanks, Paul!