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.