sort by date column

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
 
N

Niek Otten

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