View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnopp
 
Posts: n/a
Default how do I aggregate dates

Did anyone figure out how to do this? There is a posting from CommuterVet
that ends with a problem that countif only took the last one.

I have a sales forecast that is by day,month,year, and I want to subtotal by
month or put it into a pivot table and have it aggregate by month, but I
can't seem to be able to do it.