Sort by Month

G

Guest

Does anyone have a way to sort a series of dates in the "2/16/2007" format by
month? Of course, Excel wants to sort by year by default. Any thoughts?

Thanks,
Craig.
 
G

Guest

Hy Craig

try to use an auxiliar collumn with =month(a2) and use it to sort your tabke

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"CraigH" escreveu:
 

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

Sort Dates 11
Date Sorting in Excel 2003 1
Sort "mm-dd-yyyy" by year 3
Sorting date fields by month excluding year 1
Sort by date but not year 4
Sorting a date by month, date and then year. 2
Separating dates from one column to Month, Date, Year columns 2
Date Conversion 4

Top