Date Sorting

  • Thread starter Thread starter S Van Drisse
  • Start date Start date
S

S Van Drisse

Is there a way to sort a full date such as 1210/03 by the month. I can
only get excel to sort by the year.

I am trying to make a birthday list and I dont care about the year only the
month and day

Thanks In advance
 
Use a help column and a formula like

=MONTH(A2)

assuming the dates start in A2, copy down and if you want day you add
another help column and

=DAY(A2)

now select all 3 columns and sort by month help column first and second day
column both in ascending order
 
Back
Top