If your dates are recognized as dates by Excel, a pivot table will do this
and lots more in no time.

HTH. Best wishes Harald

"Need Letters in the Columns"
skrev i melding
...
I have several spreadsheet with tons of date listed. I need to group the
dates by month so i can subtotal each month. I got the subtotalling part
its the group by month that i need to do without going in and entering a
break between each month.
01/01/2008 Group as Jan
01/31/2008 Group as Jan
02/01/2008 Group as Feb
04/01/2008 Group as Apr
05/02/2008 Group as May
09/01/2008 Group as Sep