sort by date column

  • Thread starter Thread starter CEV
  • Start date Start date
C

CEV

We have a worksheet that contains a colum with the date in it like
12/26/2007. We want to be able to sort by the month but anytime we try to
sort it sorts by the year. Is there an easy way to do what we are trying to
do?

Thanks,

CEV
 
Insert a column next to this one (I assume the data is in column A). Use this formula: =MONTH(A1) and copy down

Sort both columns, using the new column as sort key

| We have a worksheet that contains a colum with the date in it like
| 12/26/2007. We want to be able to sort by the month but anytime we try to
| sort it sorts by the year. Is there an easy way to do what we are trying to
| do?
|
| Thanks,
|
| CEV
|
|
 

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 by date ? 3
sort a column by date- by month not year 5
Sort Dates by Month and Day, Not Year 4
Using a drop-down box to sort data based on seperate columns 2
Date Sorting problem in Excel 1
Question on Sorting by (date, etc) 5
Can't Convert Date to Text? 3
date format 1

Back
Top