Count dates by monthes ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
i have to columns date and name (ex : Andy - 03/01/79)
i would like to count all Andy's cells of every monthe (january=3,february=2
....)

How can I do it ?
 
Make sure you have headers, then select the table and do data>pivot table
and pivotchart report. Click next twice and select layout, drag names and
dates into the row field and drag names into the data field as well, right
click any of the cells with a date in the pivot table and select group, then
group by month
 
Since you have months you want to group you would probably get a better
looking table if you put the time header in the column field



--
Regards,

Peo Sjoblom
 
Back
Top