How to use the EOMONTH Function in Excel

In this article, we will learn about how to get the excel last day of the month.
At times, we need to know the expiry date of any product given its period of expiry and manufactured date. And you would be thinking why to do manually. Then YES. You are right. Excel function does your work here. 
EOMONTH function is used to find the last day of the given month. It requires two things:

  1. From date you wish to count or manufacturing date.
  2. Number of months from the date or its living period.


=EOMONTH( Start_date, months)

start_date : a valid date representing the start date for the function.
Months : a positive or negative number to get the date for after or before the start date.

Let’s get this with an example here.
Here we have start dates in the first columns and period of months in the second column.

Using the formula in the cell where we want the last day of the given month.



Here arguments to the function is given as cell reference.

To get the 5 months after the 1st September 2014. What is the last day of that month? The month comes out to be february and last day of feb 2015 is 28th of Feb.

Copy the formula in other cells, select the cells taking the first cell where the formula is already applied, use Ctrl + D shortcut key.

As you can see from the above example, you can find the last day of any month using EOMONTH function. 


  1. Excel records dates as serial number for calculation purpose. So valid date format or else the function returns the #NUM! Error.
  2. The start_date plus the months yields a invaild date, the function returns the #NUM! error.

Hope you understood how to find the last day of the month in Excel. Find more articles on Excel Functions here. Please share your query below in the comment box. We will assist you.

Related Articles

How to Get Month From Date in Excel

Convert Date and Time from GMT to CST

Get day name from Date in Excel

Separating Date and Time

Popular Articles

Edit a dropdown list

If with conditional formatting

If with wildcards

Vlookup by date

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.