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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All, In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂 DOWNLOAD ...
Lock the Excel Pivot Table but not the Slicer Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format. What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interact...
Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation. You can activate this by Right Clicking on your Pivot Table values and choosing Show Values As and Running Total In.  You c...
Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer. These Slicer Styles add color to your Excel workbook to gives it some much needed life! You can also add columns to a Slicer and you can also find more Slicer options by Right...