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.

YouTube video
Filter a Pivot Table by Dates | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

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

Filter a Pivot Table by Dates | MyExcelOnline

 

STEP 2: Place a date range. Click OK.

Filter a Pivot Table by Dates | MyExcelOnline

Your pivot table is now filtered by the dates!

Filter a Pivot Table by Dates | MyExcelOnline

 

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

Filter a Pivot Table by Dates | MyExcelOnline

Your pivot table is now filtered by the next quarter!

Filter a Pivot Table by Dates | MyExcelOnline

 

 

Helpful Resource:

728x90

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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