There are an array of different Date filters in a Pivot Table.  You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on.  This is useful if you want to see what invoices are due to be paid this month or what sales transactions were included in a particular quarter.

Below I show you a few quick Pivot Table filter examples.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Go to Row Labels and select Date Filters > Between

 

STEP 2: Place a date range. Click OK.

Your pivot table is now filtered by the dates!

 

STEP 3: Let us try another one. Go to Row Labels and select Date Filters > Next Quarter

Your pivot table is now filtered by the next quarter!

 

Filter by Dates

Helpful Resource:

728x90

 

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Top 3 Excel Pivot Table Issues Resolved I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.I want to put these issues to bed so you can go o...
Pivot Charts Pivot Charts in Excel are an extension of a Pivot Table and they show its values in a graphical representation.  So when you filter a Pivot Table, the Pivot Chart updates accordingly.To insert a Pivot Chart you need to click in your Pivot Table, go to the PivotTable Tools tab...
Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac.They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...
Icon Sets In A Pivot Table An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables.The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few icon sets that you can include, like:DIRECTIONAL (Change in valu...