Start Free Course
EOMONTH syntax

EOMONTH In Excel

Written by ExcelMojo Editorial Team ExcelMojo Editorial Team ExcelMojo editorial profile and article credentials. Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Reviewed for accuracy, clarity, and editorial standards. Full Bio
Updated Apr 23, 2026
Read Time 10 min

What Is EOMONTH Function In Excel?

The EOMONTH function in Excel is an inbuilt Date & Time function which returns the serial number of the last day of the month based on the supplied start date. Users can use the function EOMONTH in Excel while calculating the maturity or due dates falling on the last day of the specific month.

For example, the below table contains a list of dates entered using the DATE(), and the comments show the dates we need to calculate using EOMONTH in Excel.

Frequently Asked Questions (FAQs)

What value will be used in the months section in the EOMONTH formula to get the same month end date?


The value used in the months section in the EOMONTH formula to get the same month end date will be 0.

Suppose we need to get the same month’s end date for the start date mentioned in the below table.

FAQ 1

The steps are:

Step 1: Select cell C2, enter the EOMONTH() provided in the Formula Bar in the below image, and press Enter.

FAQ 1.1

Step 2: Select cell C2 and set the Number Format in the Home tab as Short Date.

FAQ 1.2

Once we click on Short Date, the EOMONTH() return value in cell C2 will be in the proper date format.

FAQ 1.3

The month in the start date is 3 or March. And as the argument months supplied to the EOMONTH() is 0 (cell B2), its last day, 3/31/2022, gets displayed in the target cell C2.

Why is my EOMONTH formula not working?


The EOMONTH formula may not work due to the below reasons:

1. The specified start_date, or resulting date, obtained by adding or deducting the number of months to or from the start_date is invalid.
2. The supplied arguments to the function are non-numeric.

When to use EOMONTH in Excel?


We can use EOMONTH in Excel when we have to:

1. Determine maturity dates or due dates falling on the month’s end date.
2. Calculate the number of days in a month based on the given start_date.
3. Determine the first day of a specific month from the start_date.

Download Template

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

This has been a guide to EOMONTH in Excel. Here we discuss how to use EOMONTH function with examples and downloadable excel template. You can learn more from the following articles –