Move to a month-end by whole months

Turn November 4, 2026 plus 3 months into the last day of that month: February 28, 2027.

What you'll make

In Excel: January 15, 2026 + 1 month becomes February 28, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The real date.November 4, 2026
2B8How many months away. A minus number goes back.3
3EOMONTH( … )Finds the last day of that month.February 28, 2027

Read it left to right. You always get the month's last day. Use 0 for this month.

=EOMONTH(A8,B8)

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 and numbers of months into the green columns of the Template tab. The month-ends fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use whole months. Type a minus sign, like -2, to go back in time.

Microsoft's help: EOMONTH function