Date Filters

 

This example teaches you how to apply a date filter to only display records that meet certain criteria.

1. Click any single cell inside a data set.

2. On the Data tab, click Filter.

Click Filter

Arrows in the column headers appear.

Filter Arrrows

3. Click the arrow next to Date.

4. Click on Select All to clear all the check boxes, click the + sign next to 2012, and click the check box next to January.

Click 2012, January

5. Click OK.

Result. Excel only displays the sales in 2012, in January.

Filter Result

6. Click the arrow next to Date.

7. Click on Select All to select all the check boxes.

8. Click Date Filters (this option is available because the Date column contains dates) and select Last Month from the list.

Date Filters

Result. Excel only displays the sales of last month.

Last Month

Note: this date filter and many other date filters depend on today's date.