Explainry Tutorials to Expert in IT

Date Filters in Excel

Previous lesson: Number and Text Filter in Excel

In this example, we will illustrate how to use a date filter to display record that meet certain criteria.

1- Select data and type Alt + A + T. Or go to the Data tab, in the Sort & Filter section and select Filter.

2- Arrows will appear in columns’ header. Click the arrow in the date column. A date filter menu will open.

3- From the available options, we want to select data for the current month only. For this select This Month option.

4- Excel will show data against the current month only.

Note: all available date filters are based on today’s date. In the above example, Excel shows two dates of March because today is March 12, 2019.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved