Excel Formula for Quarterly Dates: Examples and Tips

To calculate the first day of the calendar quarter containing a date in A2, use =DATE(YEAR(A2),3*INT((MONTH(A2)-1)/3)+1,1). For example, if A2 contains November 18, 2025, the result is October 1, 2025; format the result as a date to display it clearly.

Find the start and end of a calendar quarter

Excel stores dates as serial numbers, so a formula can return a genuine date rather than a text label. The quarter-start formula groups January through March into Q1, April through June into Q2, July through September into Q3, and October through December into Q4. It keeps the year of the supplied date and sets the day to 1.

With the date to check in A2, the formula returns October 1, 2025 when A2 is November 18, 2025. It also works for dates on quarter boundaries: March 31 returns January 1, while April 1 returns April 1. The key is to use a valid Excel date in A2, not text that merely looks like a date.

To return the final day of that quarter, with the same date in A2, use =EOMONTH(DATE(YEAR(A2),3*INT((MONTH(A2)-1)/3)+3,1),0). For November 18, 2025, the result is December 31, 2025. EOMONTH finds the last day of the month containing the date it is given; the inner DATE expression points it to the final month of the quarter.

These start and end formulas are useful for reporting periods, due dates, and filtering records. When you need to include all times on the quarter’s final day in a calculation, an exclusive next-quarter boundary is often safer than an inclusive end date. The SUMIFS example below demonstrates that approach.

How the quarter-start formula works

The formula combines three familiar functions. YEAR(A2) retrieves the year, MONTH(A2) retrieves a number from 1 to 12, and DATE assembles those parts into a date. The expression INT((MONTH(A2)-1)/3) assigns the month to a quarter index starting at zero: January to March produce 0, April to June produce 1, and so on.

Multiplying that index by 3 and adding 1 produces the first month of the quarter: 1, 4, 7, or 10. DATE then sets the day to 1. For a date in August, for example, INT((8-1)/3) is 2; 3 times 2 plus 1 is 7, so the constructed date is July 1 of that year.

This method avoids relying on a manually maintained lookup table and does not require a special quarter function. Excel has no built-in QUARTER function. The formula also does not depend on the display format of A2, provided its underlying value is a valid date.

Build a recurring quarterly date list

If you already have the first quarter date, the simplest approach is to move forward three months at a time. With January 1, 2025 in A2, enter =EDATE(A2,3) in A3. It returns April 1, 2025. Copy the formula down to produce July 1, October 1, and subsequent quarter starts. Each row uses the preceding row as its starting point.

EDATE advances by a specified number of months while preserving the day where possible. Starting with the first day of a quarter avoids month-end variations, so the sequence remains on the first day. If your initial date is not a quarter start, EDATE will still move it by three months, but it will not automatically align it to a quarter boundary.

In Microsoft 365 or Excel 2021 and later, you can create several dates at once with a dynamic array. With January 1, 2025 in A1 and room for eight results below the formula cell, enter =EDATE($A$1,3*SEQUENCE(8,1,0,1)). The results spill into eight cells, beginning with January 1, 2025 and continuing every three months through October 1, 2026. SEQUENCE supplies the month offsets 0, 3, 6, and so on. If cells below are occupied, Excel displays a spill error; clear the obstructing cells or choose another output area.

To create a schedule that begins after the date in A1 rather than including A1 itself, change the starting value in SEQUENCE from 0 to 1. Then the first result is three months after A1. In versions without SEQUENCE, use the EDATE formula in the first result cell and fill it down.

Use fiscal quarters instead of calendar quarters

Many organizations use a fiscal year that does not begin in January. The calendar-quarter formula will not match those periods: a company whose fiscal year starts in July, for example, treats July through September as its first fiscal quarter, not its third calendar quarter.

To calculate the fiscal quarter number when the first month of the fiscal year is stored as a number in B1, with a date in A2, use =INT(MOD(MONTH(A2)-$B$1,12)/3)+1. Enter 7 in B1 for a July start. With November 18, 2025 in A2, the result is 2 because November falls in the second three-month period after July. For April 10, 2026, the result is 4 in that same fiscal-year cycle.

This formula returns only a quarter number, not a complete fiscal-period label or date. Organizations also differ in how they name fiscal years: a year starting in July 2025 may be called FY2025 or FY2026, depending on whether the label refers to the starting or ending year. Confirm the naming rule used by your reports before adding fiscal-year text. For a fiscal quarter start date, first establish the organization’s year-label convention and expected output, then test dates on both sides of its year boundary.

Display dates and create readable quarter labels

A correct date result may initially appear as a number, because Excel stores dates numerically. Select the result cells and choose Home > Number group > Short Date, or open Format Cells to choose a longer date display. On Windows, Ctrl+1 opens Format Cells; on Mac, use Command+1. Changing the number format changes how the date looks, not the underlying date value.

For a text label such as Q4 2025, with a valid date in A2, use ="Q"&ROUNDUP(MONTH(A2)/3,0)&" "&YEAR(A2). For November 18, 2025, the result is Q4 2025. This is convenient for headings and charts, but it returns text, not a date. Text labels do not behave like date values when sorted: Q1, Q2, Q3, and Q4 may sort alphabetically in an unexpected order if combined with other labels. Keep a real date column for calculations and use the label as a presentation field.

Another common choice is to display the actual quarter start with a custom format. A date format can make a date easier to read, but it cannot turn a quarter-start date into a calculated quarter number or change the date’s value. Use a separate label formula when you need explicit text, and retain the date itself for sorting, chart axes, and date-based criteria.

Summarize transactions by quarter

Quarter dates become especially useful when paired with a transaction table. Suppose transaction dates are in A2:A5 and amounts are in B2:B5: September 15, 2025 has an amount of 10; October 1 has 100; November 18 has 50; and January 5, 2026 has 30. Put October 1, 2025 in D2 as the start of the quarter to summarize.

With those date and amount ranges, and the quarter start in D2, use =SUMIFS($B$2:$B$5,$A$2:$A$5,">="&D2,$A$2:$A$5,"<"&EDATE(D2,3)). The result is 150: the October and November transactions are included, while September is before the quarter and January is on or after the next-quarter boundary. The upper condition is exclusive, so the formula also handles transactions that have times attached to their dates on December 31 without accidentally excluding late-day entries.

For a larger table, expand the fixed ranges to cover the data, or use an Excel Table so the references can grow as rows are added. Check that the transaction-date column contains real Excel dates and that amounts are numeric; text dates or text-formatted amounts can prevent a summary from behaving as expected. This pattern also works for counts and other summaries by replacing SUMIFS with an appropriate function and preserving the same date boundaries.

Common errors and ways to avoid them

A number appears instead of a date: The result is probably a valid date serial with a General number format. Apply Short Date or a suitable custom date format.
The formula returns an error or an unexpected date: Check whether the source cell is a real date. Text imported from another system may need conversion before date functions can interpret it reliably.
The quarter seems one month off: Confirm that the input date is in the expected cell and that the formula uses MONTH(A2), not a different column or row.
The schedule drifts from the intended quarter: Begin with a true quarter-start date. EDATE advances three months from its input; it does not snap arbitrary dates to a quarter boundary.
A date range misses records from the last day: If entries include times, an inclusive test against a date at midnight can exclude later times that day. Use a less-than test for the first day of the next quarter, as in the SUMIFS example.
The formula shows a syntax error: In standard English-language Excel settings, the formulas here use commas as argument separators. Some regional settings use semicolons, so Excel may require the separator configured for that installation.

Frequently Asked Questions

What is the Excel formula to get the next quarter date?
With a quarter-start date in A2, use =EDATE(A2,3). If A2 is January 1, 2025, it returns April 1, 2025. The starting value should already be the quarter boundary you want to continue from.

Can Excel calculate a quarter number from a date?
Yes. With a date in A2, use =ROUNDUP(MONTH(A2)/3,0). A date in November returns 4. This calculates calendar quarters; a fiscal calendar with a different start month needs a fiscal-quarter calculation instead.

Why does my quarterly date formula show a number?
Excel stores dates as serial values. Select the result and apply a date format, such as Home > Number group > Short Date. The value can still be used in calculations even when it is displayed as a number.

How do I make quarterly dates for several years?
Start with the first quarter date and copy =EDATE(A2,3) down the column, adjusting the reference to the preceding row as you fill. In Microsoft 365 or Excel 2021 and later, SEQUENCE can generate a spill range in one formula.

Does the quarter-start formula work for fiscal quarters?
Not when the fiscal year begins in a month other than January. The standard formula follows calendar quarters. Use a formula based on the fiscal start month, and verify the organization’s fiscal-year naming convention before building report labels.

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.