monthly subtotals

[matmich]

I have a list of dates, how can I get the subtotals for each month?? I
only want to show the change in the month.

thanks

 

[Debra Dalgleish]

You could use a pivot table to summarize the data, and group the dates
by month. There are instructions in Excel's Help, and Jon Peltier has
instructions and links:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

To group the dates:

http://www.contextures.com/xlPivot07.html