I have a list of information that I want to insert subtotals for. I want a
monthly subtotal for the information but my dates in the spreadsheet exist in
the format dd/mmm/yy. Consequently when I use the subtotal function it views
each day as a change in date and just counts the number of incidents per day
as opposed to per month which is what I want. I want it to look at the change
in the mmmm part of the date and subtotal as oppsed to the change in the dd
part.
Thanks in advance
--
mrsatroy