Find the end of a custom fiscal quarter

Turn November 4, 2026 with a July start into December 31, 2026, its quarter end.

What you'll make

In Excel: November 4, 2026 with a July start becomes December 31, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesFor row 8
1A8The real date.November 4, 2026
2MONTH(A8)-B8Months between the date and the start month.4
3MOD( … ,3)How many months into its quarter the date is.1
42-MOD( … )Months left until the quarter's last month.1
5EOMONTH( … )Moves ahead that many months, then finds the last day.December 31, 2026

Excel works from the inside out: part 2 first, then MOD, then 2 minus it, then EOMONTH.

=EOMONTH(A8,2-MOD(MONTH(A8)-B8,3))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own dates. Paste real dates into the green Date column and the start month number next to each. The quarter end dates fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Type the start month as a number from 1 to 12, like 7 for July.

Microsoft's help: EOMONTH function