How to Filter Dates by Quarter in Excel


Often you may want to filter dates by quarter in Excel.

Fortunately this is easy to do using the Filter function.

The following step-by-step example shows how to use this function to filter dates by quarter in Excel.

Step 1: Create the Data

First, let’s create a dataset that shows the total sales made by some company on various days:

Step 2: Add a Filter

Next, highlight the cells in the range A1:B14 and then click the Data tab along the top ribbon and click the Filter button:

A dropdown filter will automatically be added to the first row of column A and column B:

Step 3: Filter Dates by Quarter

Next, we’ll filter the dataset to only show the rows where the date is in Quarter 1 (January, February or March).

Click the dropdown arrow next to Date, then hover over Date Filters, then hover over All Dates in the Period, then click Quarter 1:

Excel filter by quarter

The dataset will automatically be filtered to only show the rows where the date is in Quarter 1:

Notice that only the rows with dates in January, February or March are visible.

Additional Resources

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

How to AutoFill Dates in Excel
How to Group Data by Month in Excel
How to Calculate the Difference Between Two Dates in Excel

Leave a Reply

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