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

GETPIVOTDATA Function What does it do? A formula that extracts data stored in a Pivot Table Formula breakdown: =GETPIVOTDATA(data_field, pivot_table, , ,...) What it means: =GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...)   T...
Filter Unique Records The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis. This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will ...
Conditional Format a Cell´s Value A great way to highlight values within your data set, Excel Table or Pivot Table is to use Conditional Formatting rules. Formatting cells that contain a specific criteria, for example, greater than X or less than X, is a good way to visualize your results. When your criteri...
Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values. The length of the data bar represents the value in the cell.  A longer bar represents a higher value. You have a Gradient Fill or a Solid Fill to choose from as well ...