Create a column, generate the month out of the dates , eg.

=month(A1)

where A1 is your date column. Then you can create a pivot table to sum up or
subtotal grouping based on the month number.


"Blue Fish" wrote:

Hello:

I have the excel that it will record down how many items sold out.
May I know how can I calculate how much items has been sold out by every
month?

Thanks a lot!

Date Items Sold Out
1-Oct-2008 2
30-Oct-2008 3
4-Nov-2008 4
3-Mar-2008 6
2-Feb-2008 5
6-Nov-2008 12
6-Mar-2008 16