I'm not sure what you're using to subtotal, but if it's dates, then maybe you
can add a helper column to your data:

=text(a2,"yyyy-mm")
and drag down
(assumes that a real date is in A2)

David Portwood wrote:

I have a small database consisting of dates and sales amounts. I would like
to subtotal the sales amounts for each month. However, no matter what I do,
Excel subtotals for each day. Is it possible to break this down by month? I
would appreciate any help. Thank you.

--

Dave Peterson