Table of Contents
Filtering dates by quarter in Excel allows you to easily view and analyze data within a specific time frame. To do this, you will need to first select the date column you want to filter. Then, go to the “Data” tab and click on the “Filter” button. Next, click on the arrow next to the date column header and select “Filter by Quarter.” This will open a drop-down menu where you can choose the specific quarter you want to filter by. Once selected, only the dates within that quarter will be displayed, making it easier to analyze and work with your data. This feature is especially useful for tracking quarterly trends or comparing data between different quarters.
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:
The dataset will automatically be filtered to only show the rows where the date is in Quarter 1:
Additional Resources
The following tutorials explain how to perform other common operations in Excel: