How to Filter Dates by Quarter in Excel

Formulas & functions · Updated November 20, 2026

To filter dates by quarter in Excel, turn on the filter for your date column and choose the relevant quarter from its date groups. If Excel does not show quarter groups, or you need to distinguish the same quarter in different years, add a helper column that labels each date by quarter and year, then filter that column. Start with dates stored as real Excel dates, not text.

What You’ll Need

  • A worksheet with a header row and a column of dates, such as order dates in column A.
  • Microsoft Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web have similar filtering concepts, but the menu layout can vary slightly.
  • For the helper-column method, an unused column beside your data. You do not need an add-in or a special template.

It also helps to know whether you mean a quarter in any year—for example, all January-to-March dates—or a specific calendar quarter, such as Q1 2025. The built-in date filter can display dates grouped by year and quarter; a quarter-and-year helper label makes that distinction explicit and easy to reuse.

Step-by-Step

  1. Check that the date column contains real dates. Click a date cell and look at the formula bar. A recognized date is generally stored as a number, even when it is displayed in a format such as 3/15/2025. You can change its display using Home > Number Format, but formatting alone does not convert text into a date. If the values are left-aligned or do not sort chronologically, they may be text; see Troubleshooting before filtering.
  2. Make sure the data has a single header row. Each column should have a unique, nonblank heading, such as Order Date, Customer, and Amount. Remove fully blank rows or columns inside the data area because they can cause Excel to detect only part of the list. If the range is used regularly, select a cell in it and press Ctrl+T on Windows, confirm that My table has headers is selected, and click OK. On a Mac, use Command+T. An Excel table automatically carries filters to new rows added at its bottom.
  3. Turn on the filter arrows. Click a cell in the data range or table, then choose Data > Filter. Excel adds a dropdown arrow to each header. If arrows already appear, filtering is already enabled. Avoid selecting just the date cells: the filter should apply to the full set of rows so that related information stays together.
  4. Open the date column’s dropdown. Click the arrow beside the date heading. If Excel recognizes the entries as dates, the checklist is usually organized into a hierarchy of years, quarters, and months. Expand the relevant year, then select the quarter you want, such as Qtr 1. Clear the other quarter checkboxes as needed, and select OK. The filtered worksheet shows only matching rows; other rows are hidden, not deleted.
  5. Check whether the year is part of your selection. If you select a quarter nested under one year, you have filtered for that quarter in that year. To show Q1 across several years, select the Q1 entries under each applicable year, if the dropdown offers them. The date checklist can be long, so use its search box if available to locate a year, but confirm the quarter selection before clicking OK. This distinction matters when comparing seasonal results over multiple years.
  6. Use a date range if you want exact quarter boundaries. Open the date dropdown and choose Date Filters > Between. Enter the quarter’s first day and the first day of the following quarter, making the second boundary exclusive by using a formula-based helper or a carefully chosen final date. For a calendar Q2 in 2025, for example, the start is April 1, 2025 and the last included date is June 30, 2025. In the Between dialog, enter those two inclusive dates. This is useful when the checklist is awkward or when you know the exact period.
  7. Add a quarter-and-year helper column when you need a repeatable label. Add a heading such as Quarter and Year beside the date column. With dates in A2:A100 and the new heading in B1, enter this in B2: ="Q"&ROUNDUP(MONTH(A2)/3,0)&" "&YEAR(A2). For a date of March 15, 2025 in A2, the result is Q1 2025. Fill the formula down the rows, then choose Data > Filter if the new column is not already included in the filtered range. Use the helper column’s dropdown to select a label such as Q1 2025.
  8. Alternatively, make a quarter-only helper label. With dates in A2:A100, enter this in B2: ="Q"&ROUNDUP(MONTH(A2)/3,0). It returns Q1 for January through March, Q2 for April through June, Q3 for July through September, and Q4 for October through December. Filter the helper column to select a quarter. Because this label does not include a year, selecting Q1 will combine Q1 dates from every year in the data.
  9. Review the filtered rows and clear the filter when finished. Check a few visible dates against the intended quarter and year. To restore all records, open the relevant dropdown and choose Clear Filter From [column heading], or use Data > Clear to clear filters on the sheet. Clearing a filter reveals hidden rows; it does not remove data or erase the helper formulas.

For a PivotTable, the workflow is different: right-click a date displayed in the PivotTable, choose Group, select Quarters (and Years if you need year-by-year results), and click OK. You can then filter the grouped quarter field. If Group is unavailable, the source dates may contain text, blanks, or invalid entries, or the PivotTable may be based on a data model that does not support this grouping operation.

Common Mistakes

Filtering a quarter without checking the year. Q1 happens every year. Choosing Q1 under 2025 is not the same as selecting Q1 under several years, or using a helper formula that returns only Q1. Decide which result you need before filtering, especially before copying visible rows into a report.

Assuming date formatting fixes text. Applying a date number format changes how Excel displays a value; it does not necessarily turn imported text into a date serial number. A text value can look like a date and still fail to appear in the date hierarchy. Convert or re-import the values correctly before relying on date filters.

Applying the filter to only one column. Sorting or filtering dates without including the corresponding names, amounts, or other fields can separate records from their details. Select a cell in the complete data range before using Data > Filter, and check that every heading has an arrow.

Using the wrong definition of a quarter. Excel’s normal calendar quarters are January–March, April–June, July–September, and October–December. A business may use a fiscal year that starts in a different month. The built-in calendar-quarter groups will not automatically reflect a custom fiscal calendar; create a suitable helper formula or use a fiscal-period table instead.

Expecting the filter to delete other dates. AutoFilter hides rows that do not match. If you copy, print, or export the results, check that you are using the visible filtered records and that no other filters are active.

Tips

Use the quarter-and-year helper label for analysis that spans multiple years. A text label such as Q1 2025 is straightforward to filter, but alphabetic sorting may put Q1 before Q2 while years sort as text in an unexpected order. If chronological sorting is important, keep the original date column and sort by it, or use a separate quarter-start date as the sort key.

For a formula-based quarter-start date, with a real date in A2, enter =DATE(YEAR(A2),3*INT((MONTH(A2)-1)/3)+1,1). For March 15, 2025, the result is March 1, 2025. Format the helper column as a date, then filter or sort by it. This gives each record a real date value representing the first day of its calendar quarter, rather than a text label.

When the list changes often, convert it to an Excel table before adding helper formulas. Enter the formula in the first data row of the helper column; Excel tables usually fill the formula down the column and extend the table filter as new rows are added. If you use a normal range, include newly added rows in the range before expecting them to appear in the filter.

For a quick one-time check, the built-in date grouping is usually the simplest route. For a recurring report, a helper column is often easier to audit because each record visibly carries its quarter label. Keep the underlying date column too: it supports exact date comparisons, chronological sorting, and later changes to the reporting period.

Troubleshooting

The dropdown shows individual values instead of a year/quarter hierarchy. Excel may be treating some or all entries as text, or the column may contain mixed values. Test a cell with =ISNUMBER(A2) when the suspected date is in A2; a real Excel date returns TRUE. If it returns FALSE, convert the source values. Depending on their format, select the column and use Data > Text to Columns, choose the appropriate date order on the final screen, and finish the conversion. For dates with mixed regional formats, confirm whether the source means month/day/year or day/month/year before converting.

The filter includes dates outside the quarter. Check the selected year as well as the quarter, and look for text dates or timestamps that may not be interpreted as expected. If using Date Filters > Between, verify both boundary dates and whether you entered the final day inclusively. To avoid ambiguity for records that include times, a helper that compares dates to the first day of the quarter and the first day of the next quarter can be more reliable than filtering through the final day.

The helper formula returns an error or an unexpected quarter. Confirm that the date reference points to the correct column and that the cell contains a valid date. The quarter formula uses the month number: months 1–3 return Q1, 4–6 Q2, 7–9 Q3, and 10–12 Q4. If the first data row is not row 2, adjust A2 to the correct cell, then fill down. If Excel displays the formula as text, change the cell format to General and re-enter the formula.

New records do not appear in the filter. Check whether they were added outside the filtered range. With a regular range, reselect the entire list and choose Data > Filter again. With a table, add the records immediately below the last table row or resize the table using Table Design > Resize Table. Also make sure new date entries are real dates and that the helper formula has filled into their rows.

The Group command is disabled in a PivotTable. Inspect the source date field for blanks, errors, and text values, correct them, and refresh the PivotTable. If the PivotTable uses the Data Model, grouping may not be available in the same way; use a quarter field in the source data or create a date table with quarter information.

Frequently Asked Questions

Can Excel filter dates by quarter without a formula?
Yes. If Excel recognizes the column as dates, open its filter dropdown and select the quarter from the date hierarchy. A helper formula is optional, but it is useful for repeatable labels and for distinguishing quarters across years.

How do I filter Q1 across all years?
Select Q1 under each year shown in the date hierarchy, or use the quarter-only helper formula and filter for Q1. Do not use a single Q1 2025 label if you want dates from other years too.

How do I filter by a fiscal quarter?
The built-in quarter groups use calendar quarters. For a fiscal year that starts in another month, calculate the fiscal quarter with a formula based on your start month or maintain a fiscal calendar table, then filter that field. Confirm the organization’s fiscal-year naming convention as well as its start month.

Can I filter a PivotTable by quarter?
Usually, yes. Right-click a valid date in the PivotTable, choose Group, select Quarters, and include Years if needed. Then use the grouped field to filter. Source blanks, invalid dates, or some Data Model setups can prevent direct grouping.

Will filtering change or delete my original data?
No. A normal worksheet filter hides rows that do not match. Clear the filter to see them again. Avoid deleting rows unless you intentionally want to remove records from the source data.

Why does Excel show the wrong quarter for a date?
Check the actual stored date and the intended calendar or fiscal definition. Regional date interpretation can turn an imported value into a different date than its appearance suggests, while fiscal quarters may not match Excel’s January-based calendar quarters.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.