Pivot Table

Occasional Visitor

I created a PivotTable.  I selected "date posted" field to be included.  In the PivotTable fields Excel added fields Month, Qtr, Year.  I don't know how it did it or what I did that resulted in the additional fields but I need to know so I can do it again as it was very useful.  

1 Reply

@Pamela4341 That's by default, unless you tell Excel to disable this automatic grouping of dates. That said, it only works if the dates are real dates. Excel stores dates as numerical values which you can then format in different ways (e.g. 10 August 2022, 10/08/2022, August 10, 2022 or 8/10/22). It does not work when the dates are in fact texts. You can check that with the ISNUMBER function that returns TRUE for real dates and FALSE for texts that may look like dates.