Ranks in a Pivot Table: By using a pivot table, you can summarize your data in an understandable.

Heres the point: Lets say you want to group all the dates as months instead of adding a different column in your data, its better to group dates.

Its super easy. Now heres the good news Apart from months, you can use years, quarters, time and even a custom date range for grouping.

And today in this post, Id like to show you the exact steps for this.

Different Ways to Group Dates in a Pivot table Below are some of the useful ways for grouping date and time values in a pivot table to make instant reports.

By Months By Weeks Hourly Summary Custom Date Range Grouping Two Different Fields Lets get started.

NOTE: Pivot Tables are one of the INTERMEDIATE EXCEL SKILLS.

Quick Tip: You can also use above steps to group dates in a pivot table by years, quarters, and days.

Groups of 7 Days to Create Weekly Summary You can also create a group of 7 days to get a week wise summary.

Enter 7 in a number of days.

Click OK. Quick Note: You can use above steps to create a group of dates for any number of days and please note that week created by pivot table is not on the basis of Mon-Sun.

An Hourly Summary if You Have Time with Dates You also have an option to group dates by time period.

Lets say if you have dates with time and you want to get an hourly summary.

Select hour from the group by option.

Click OK. Quick Tip: You can also use above steps to group dates in the pivot table by minutes and seconds.

Creating a Custom Date Range Summary In below pivot table, you have dates ranging from 01-Oct-2014 To 31-Jun-2015.

And you want to create a group of dates by months..but..only for 6 months of 2015 and all the month of 2014 in one group.

Well, you can also create a group of dates by using a custom range..follow these simple steps for this.

In above pivot, now you have dates in a group by months for the date range you have mentioned and rest of the dates which are not in the date range are in a single category.

Grouping Two Different Fields It happens sometimes..that you need to use more than one-time span to group dates in a pivot table.

Lets suppose..in below pivot table you want to group dates by quarters and months.

In the End, Using the option to group dates in a pivot can be a big time saver.

You dont need to insert those extra columns in your source data.

And the best part You have different options to combine dates.

I hope this tip will help you get better at Excel but now tell me one thing.

Are you going to try this option Please share your views with me in the comment section.

Id love to hear from you, and please, dont forget to share this post with your friends, I am sure they will appreciate it.

Share 0 Tweet 0 More Pivot Table Tips Apply Conditional Formatting to a Pivot Table: It will highlight city which has the highest.

Automatically Update a Pivot Table Range: The point is, you need a method to update source.

Pivot Table Timeline in Excel: A timeline is a new feature introduced in Excel 2013 and the good news.

Create A Pivot Table Excel For Mac 2014