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
 
You must log in or register to reply here.

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 2
Information for Pivot Table 3
Changing date to eliminate day in format mm/dd/yyyy 1
counting records by month and year / date format issues 1
Pivot Table date format 1
Grouping Date Fields in Pivot Table 2
Pivot Table 1
Pivot Table Date Format 2

Back
Top