EOMONTH Function

Returns the last day of the month, a given number of months away.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A date (serial number)

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

EOMONTH (end of month) returns the last day of a month — the current month with 0, next month with 1, last month with -1.

It handles 28-, 30- and 31-day months and leap years automatically.

Syntax

=EOMONTH(start_date, months) Explain

Arguments

ArgumentRequired?What it does
start_dateYesAny date in the starting month.
monthsYes0 for the same month, positive for later months, negative for earlier ones.

Examples

Example 1 — Month-end for each date

Find the reporting month-end for each transaction.

B2fx=EOMONTH(A2,0)
AB
1DateMonth end
23/15/20263/31/2026
32/10/20262/28/2026
42/10/20282/29/2028
=EOMONTH(A2,0) Explain

Example 2 — Payment due at the end of next month

Northstar's terms are "end of month following".

B2fx=EOMONTH(A2,1)
AB
1Invoice dateDue
23/15/20264/30/2026
312/3/20261/31/2027
=EOMONTH(A2,1) Explain

Example 3 — First day of the month

The end of last month plus one day.

=EOMONTH(A2,-1)+1 Explain

Common mistakes

  • The result shows as a number. Format the cell as Short Date.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.