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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format 2
Sum workdays by month from List of Start/End dates 4
Date Function Help 6
Count number of cells containing a specific date range 7
Access Count dates within a Month 4
Count Days? 6
wrong format for month in cell 4
Extracting data from Multiple columns to a Single row 1

Back
Top