Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Years.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Right click on your Date values and choose Group.

 

STEP 2: Select the combination of grouping you prefer. Click OK.

Your pivot table is now grouped by dates!

Group Dates

Helpful Resource:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Repeat All Item Labels In An Excel Pivot Table Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column. Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet. The best layout to use is either the Outli...
Customize an Excel Slicer   Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging from Light to Dark and with a few colors to choose from. What if you wanted to create your own Slicer using your creative mind with super cool colors and f...
Insert Blank Rows In a Pivot Table Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky... There is a cool little trick that most Excel users do not know about th...
Protected: What Else Can Excel Pivot Tables Do?  The Pivot Table Webinar Replay & Xtreme Pivot Table Online Course is Closing its Doors in... Click Here To Watch The Webinar Replay BONUS VIDEO:   Consolidate Multiple Sheets & Excel Tables In this training you are going to learn the following:C...