sort data by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have my cells fromatted as "date" 2-MAR-81. When I sort the column it
sorts it by the year either ascending or descending depending on my
selection. I want excel to sort the info in the column by the month rather
than the day or year. I have 485 "dates" in 1 column and I would like it to
sort by Month then Day. I tried to do this by going:

Data
Sort
Options
First Key Sort order
Jan,Feb,Mar Etc.

But it still won't work it keeps sorting the column by the year. PLEASE
someone help me out!
 
Hi
one way: Use a helper column with the formula
=MONTH(A1)
copy this for all rows and sort with this column
 
In another column, enter a formula to change the date to text, then sort
by the new column.

For example, if the first date is in cell A2, enter the following
formula in cell H2:

=TEXT(A2,"mm dd yyyy")

Copy the formula down to the last row of data
Sort on column H, and the records will sort by month, day, and year.
 
Back
Top