Sorting In Excel

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,
 
P

Peo Sjoblom

You have to add a help column


=MONTH(A2)

copy down and then sort on the help column
 
J

Jason Morin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating dates from one column to Month, Date, Year columns 2
Changing date to eliminate day in format mm/dd/yyyy 1
Problem sorting by date after 2029 on Excel 2003 1
Date Format and Sumproduct 9
Sorting date fields by month excluding year 1
Date Sorting in Excel 2003 1
Sorting Dates as Numbers 2
Sorting a date by month, date and then year. 2

Top