EOMONTH Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

EOMONTH is an Excel Date & Time function. Returns the last day of the month, a set number of months away.

EOMONTH syntax

=EOMONTH(start_date, months)

EOMONTH is used in scheduling, deadline tracking, and reporting that spans specific date ranges.

Open the live Excel-style spreadsheet and try EOMONTH yourself. No Excel install or sign-up needed to start.

Read the tutorial: How to use EOMONTH.

What does the EOMONTH function do in Excel?

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

What is the syntax of EOMONTH in Excel?

The syntax is =EOMONTH(start_date, months). start_date: The date to start counting from; months: How many months to shift by.

Where can I practice EOMONTH online for free?

Open the free live spreadsheet on Cellgrids and try EOMONTH yourself. No Excel install is needed and you can start without signing up.