Apr 15 2021 01:02 PM
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?
Apr 15 2021 01:11 PM
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.
Apr 15 2021 01:22 PM