Excel Advanced Filter: How to Filter Using Date Range


You can use the Advanced Filter function in Excel to filter the rows in a dataset based on a date range.

The following example shows how to do so.

Example: How to Use Date Range in Excel Advanced Filter

Suppose we have the following dataset that shows the total sales made on various dates by some company:

Now suppose we’d like to filter for rows where the date is between 1/20/2023 and 2/20/2023.

To do so, we can define a criteria range with the two dates:

Next, we can click the Data tab and then click the Advanced Filter button:

We’ll choose A1:B11 as the list range and D1:E2 as the criteria range:

Once we click OK, the dataset will be filtered to only show rows where the date is between 1/20/2023 and 2/20/2023:

Notice that each date in the filtered data is between 1/20/2023 and 2/20/2023.

Note: If you’d like to filter the rows to include the beginning and ending dates then you can use >= and <= operators in the criteria range instead of the > and < operators.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

Excel Advanced Filter: How to Use “Does Not Contain”
Excel Advanced Filter: How to Use “Contains”
Excel Advanced Filter: Display Rows with Non-Blank Values

One Reply to “Excel Advanced Filter: How to Filter Using Date Range”

  1. Off course it was useful for me. While using only advance filter result was ok. But when I was using Macro to filter data with two date conditions, couldn’t get the proper result. The filtered data column became absolutely blank.
    What may be the reason behind this. Pl suggest if possible.

Leave a Reply

Your email address will not be published. Required fields are marked *