Wauvel

Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All functions

EOMONTH

Dates

The last day of a month N months out — clean period-end dates.

Difficulty

Amateur
Excel file

1What is it?

EOMONTH returns the last calendar day of the month that is a given number of months before or after a start date. It's the cleanest way to generate month-end dates for reporting periods and schedules.

2What it looks like

EOMONTH(start_date, months)
start_date
Any date in the starting month.
months
How many months forward (+) or back (−). 0 = end of this month.

3When you use it

  • Generate a row of period-end dates for a forecast.
  • Find the due date as end of next month: EOMONTH(invoice, 1).
  • First of next month: EOMONTH(date, 0) + 1.

4See it in action

Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.

Start simple · 1 of 2

Last day of the month for the date in B2.

C2
fx
=EOMONTH(B2, 0)Feb 28, 2026
ABC
1FieldValueResult
2Start date2/10/2026Feb 28, 2026

The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.

5Common errors

Shows a numberThe cell isn't formatted as a date.

Fix: Format the cell as Date — the underlying value is a date serial number.

#VALUE!start_date isn't a real date.

Fix: Make sure the input is a date, not text that looks like one.

6Better functions & alternatives

  • EDATE — Same day N months out (not the month-end).
  • DATE — Build a date from year, month, day for full control.

Want EOMONTH already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.

Learn the moves here — or let Wauvel run them on your numbers.

Get my free report →