EOMONTH Function in Excel: Last Day of a Month

📎 This article includes 1 downloadable practice file ↓

⏱ 1 min readUpdated 28 September 2026

Date & TimeLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Example 3
  6. Related functions

EOMONTH returns the last day of the month, a number of months away from a date.

Syntax

=EOMONTH(start_date, months)
Argument What it means
start_date A date.
months 0 = this month, 1 = next, −1 = last.

Examples

Example 1

=EOMONTH(A2, 0)

Month-end of the invoice date.

Example 2

=EOMONTH(A2, -1)+1

First day of A2’s month.

Example 3

=DAY(EOMONTH(A2, 0))

Number of days in the month.

EDATE · DATE · NETWORKDAYS

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

📎 Practice files for this article

  • 📗
    Date scenarios workbookMonth maths, financial-year start, working days with holidays — with PASS/FAIL checks and the 2 most common date mistakes.
    ⬇ XLSX · 8 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.

Keep reading

Excel Functions A–ZHLOOKUP Function in Excel: Look Up Across the Top Row of a TableExcel Functions A–ZWEEKDAY Function in Excel: Day of the Week as a NumberExcel Functions A–ZFILTER Function in Excel: Return Every Row That Matches
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong