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


--
matmich
------------------------------------------------------------------------
matmich's Profile: http://www.excelforum.com/member.php...fo&userid=7011
View this thread: http://www.excelforum.com/showthread...hreadid=472764

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

matmich wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html