Pivot Table with Dates

New Contributor

When I do a pivot table it only shows the month rather than the entire date.  For example it shows May instead of 05/01/2018.  What am I doing wrong?


2 Replies


Do you see each month only once? If so:

In many situations, Excel automatically groups dates in the Rows or Columns area of a pivot table.

Right-click any of the months in the pivot table and select Ungroup from the context menu. You should then see each individual date.


Otherwise, try changing the number format of the dates to the date format of your choice.

Thank you so much. Clicking on Ungroup took care of my issue.