How to use the Excel EOMONTH function

EOMONTH function – The function returns the last day in the month before or after 1 day of a specified number of months in Excel.

Syntax: =EOMONTH(start_date, months)

The EOMONTH function syntax has the following arguments:

  • Start_date (required argument) – This is the initial date. We need to enter dates in date format either by using the DATE function or as results of other formulas or functions. For example, use DATE(2017,5,13) for May 13, 2017. This function will return errors if dates are entered as text.
  • Months (required argument) – This is the number of months before or after start_date. A positive value for months yields a future date; a negative value produces a past date.

Example: Let’s look at some Excel EOMONTH function examples and explore how to use the EOMONTH function as a worksheet function in Microsoft Excel:

Excel EOMONTH function 1 - How to use the Excel EOMONTH function

Syntax:  =EOMONTH(A2,B2)

Result:

Excel EOMONTH function - How to use the Excel EOMONTH function

Add a Comment

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