I have an excel spreadsheet, inserted into a pivot table. One column has a list of individual days of the month. Once the pivot table is created, I group the individual days as month.
The days are listed as 3/1/2015, 3/2/2015, etc.
However, when I group into the pivot table, the months are listed as simply Mar, Apr, etc.
Is there a way to add the year when grouping individual days into months in an excel pivot table?