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

Show the Difference From Previous Month with Direc... Using a Pivot Table you can show the variance from your previous month's sales very easily...See how to Show The Difference From Previous Months With Excel Pivot Tables hereNow that we have the Pivot Table report above, we can show the variances per month using an up/...
Insert Grand Totals to a Pivot Table When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total.How about if you want to remove this Grand Total or show it only for a row or column?Well you have that flexibility and this is how...DOWNLOAD EXCEL...
50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count.This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit.DOWNLOAD...