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