Sorting In Excel

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

Marilyn

I have a column in excel full of dates. The format is as
follows: mm/dd/yyyy. I want to sort by that column,
however, when I do excel sorts by the year. I tried
changing the format so that only the month, and day are
display, however, it still sorts by year.

Can anyone tell me if there is a way of sorting this
column by the actual month and not the year?

Thanks,
 
Use a helper column with the formula:

=MONTH(A1)

Then select both columns and sort ascending by the helper
column, descending on the date column.

HTH
Jason
Atlanta, GA
 
Back
Top