Pivot Table with Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2275110%22%20slang%3D%22en-US%22%3EPivot%20Table%20with%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275110%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20do%20a%20pivot%20table%20it%20only%20shows%20the%20month%20rather%20than%20the%20entire%20date.%26nbsp%3B%20For%20example%20it%20shows%20May%20instead%20of%2005%2F01%2F2018.%26nbsp%3B%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2275110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

@Kathy_N0729 

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.