First & Last Day of a Quarter

All versionsEOMONTH

Roll any date to the start or end of its calendar quarter — for quarterly reports, accruals, and period boundaries. A little month math with EOMONTH snaps to the quarter edges.

Quick formula: last day of the quarter containing A2:

=EOMONTH(A2, MOD(3 - MOD(MONTH(A2)-1, 3), 3))

Or more simply, quarter-end = EOMONTH(DATE(YEAR(A2), ROUNDUP(MONTH(A2)/3,0)*3, 1), 0).

Functions used (tap for the full reference guide):

EOMONTH ROUNDUP

The example

A May date maps to the Q2 boundaries.

	A	B
1	Date	Quarter end
2	5/14/2026	6/30/2026

The formula

Snap to the quarter end:

=EOMONTH(DATE(YEAR(A2), ROUNDUP(MONTH(A2)/3,0)*3, 1), 0) // May → 6/30 (Q2 end)

How it works

Find the quarter’s last month, then its month-end:

ROUNDUP(MONTH(A2)/3, 0) gives the quarter number (1–4); times 3 is the quarter’s last month.
DATE(year, lastMonth, 1) builds a date in that month; EOMONTH(…, 0) returns its last day.
For the quarter start, use the first month: DATE(YEAR(A2), (quarter-1)*3+1, 1).
For a fiscal quarter (non-January start), offset the month first — see the fiscal-year-quarter recipe.

Next quarter end? Add 3 months before taking the month-end: =EOMONTH(thisQuarterEnd, 3). Great for “due at end of next quarter” dates.

Try it: interactive demo

Live demo

Pick a date; see its quarter boundaries.

Start · End

Variations

Quarter start

First day:

=DATE(YEAR(A2), (ROUNDUP(MONTH(A2)/3,0)-1)*3+1, 1)

Next quarter end

Add 3 months:

=EOMONTH(quarterEnd, 3)

Quarter number

1-4:

=ROUNDUP(MONTH(A2)/3, 0)

Pitfalls & errors

Calendar vs fiscal. This assumes Jan–Mar = Q1. For an April or July fiscal start, shift the month first.

Format as a date. EOMONTH returns a serial number.

Real dates only. Convert text dates with DATEVALUE.

Practice workbook

📊

Download the free First & Last Day of a Quarter practice workbook

A quarter-boundary calculator with start, next-quarter, and quarter-number variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I find the end of the quarter in Excel?

Use =EOMONTH(DATE(YEAR(A2), ROUNDUP(MONTH(A2)/3,0)*3, 1), 0). It finds the quarter's last month and returns its last day.

How do I get the quarter start date?

Use the first month of the quarter: =DATE(YEAR(A2), (ROUNDUP(MONTH(A2)/3,0)-1)*3+1, 1).

How do I handle a fiscal (non-January) quarter?

Offset the month by the fiscal start before computing the quarter — see the fiscal year & quarter recipe.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: EOMONTH · ROUNDUP