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
|
|
 
Back
Top