Pivot Table based on date

  • Thread starter Thread starter Newbie
  • Start date Start 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?
 
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
 
Back
Top