Excel Advanced Filter: How to Filter by Month


You can use the Advanced Filter function in Excel to filter the rows in a dataset by month.

The following example shows how to do so.

Example: How to Filter by Month 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 in March.

To do so, we can create a new column that contains the month for each date by typing the following formula into cell C2:

=MONTH(A2)

We can then click and drag this formula down to each remaining cell in column C:

Column C now contains the month number for each date in column A.

Next, type the column name we’d like to filter on in cell E1 and the month we’d like to filter for in cell E2:

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

We’ll choose A1:C12 as the list range and E1:E2 as the criteria range:

Excel advanced filter by month

Once we click OK, the dataset will be filtered to only show rows where the date is in March:

Notice that each date in the filtered data is in March.

If you’d like to filter using a range of months, you can define two months as criteria.

For example, you can use the following syntax to filter the data for dates that have months between February and April:

Once we click OK, the dataset will be filtered to only show rows where the date between February and April:

Notice that each date in the filtered data is between February and April.

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 *