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

Leave a Reply

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