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.
The following tutorials explain how to perform other common tasks in Excel: