Pivot Table based on date

N

Newbie

Hi,

I want to have a pivot-table that counts the no. of records based on month
of year - my list contains dates in the format dd/mm/yyyy

How can I get the pivot table to only be based on the month?
 
K

Ken Wright

As long as you have no blank spaces where dates should be, right click on the
dates within the Pivot table and select Group / Outline. You will likely find
Months is already selected, but if your data spans more than one year you will
also need to click on Years as well, else it will group all Jans together, all
Febs together etc.

If you get a message that says unable to group, then you have blanks somewhere
in your date fields in your source data table
 
Top