Forum Discussion

crgregory's avatar
crgregory
Copper Contributor
May 04, 2022

Excel sorting by month, day

Need assistance sorting by month-day

9/15/1967

9/27/1945

9/4/1975

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor

    crgregory 

     

    If I understand what you're asking, I personally would create "helper columns" to isolate the month and the day from the full date as shown. Then base your sort on those extracted values.

     

    (I'm assuming you want all of the Sept firsts (regardless of year) to precede any Sept seconds, regardless of year. If that's not what you're aiming to do, then please come back with a more complete description of your task.)

Resources