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