Excel 2016 – 3.1.4 – Group a PivotTable By Date
The dates in the Date column span 2 years. This is the correct way to input dates in your dataset, if you want to create a PivotTable. However, to display the information by Year we need to know how to Group those dates. We’ll take it a step further and Group by Quarter, within Year.
Download the supporting documents we use in our videos: