Count dates by monthes ?

H

hasdou

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 ?
 
P

Peo Sjoblom

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
 
P

Peo Sjoblom

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
 
Top