Pinterest Pixel

Filter a Pivot Table by Dates

John Michaloudis
Free Practice Workbook
Filter a Pivot Table by Dates.
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.
Filter a Pivot Table by Dates | MyExcelOnline Filter a Pivot Table by Dates | MyExcelOnline

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

Download excel workbookFilter-by-Dates.xlsx

 

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

Filter a Pivot Table by Dates

 

STEP 2: Place a date range. Click OK.

Filter a Pivot Table by Dates

Your pivot table is now filtered by the dates!

Filter a Pivot Table by Dates

 

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

Filter a Pivot Table by Dates

Your pivot table is now filtered by the next quarter!

Filter a Pivot Table by Dates

 

If you like this Excel tip, please share it
LinkedInCopyPrintReddit
Filter a Pivot Table by Dates | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  What Else Can Excel Pivot Tables Do?

Steps To Follow

Data Sorting and Filtering in ExcelExcel Pivot Tables TutorialsFilter

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!
Share to...
BufferCopyFlipboardHacker NewsLineLinkedInMastodonMessengerMixPinterestPocketPrintRedditSMSTelegramThreadsTumblrVKWhatsAppXingYummly