Formulas and functions > Functions from A to Z > EOMONTH (end of month in n months)

Syntax:

EOMONTH(StartDate, m)

Description:

This returns the last day of the month that is m months before/after StartDate.

The argument StartDate must be a valid date value, as the function will return the error value #VALUE otherwise!

m is the number of months.

If m is zero, the last day of the same month will be returned.

If m is positive, a date in the future will be returned.

If m is negative, a date in the past will be returned.

m should be an integer. If this is not the case, Calculate automatically removes the decimal places.

Example:

EOMONTH("09/25/2018", 0) returns 09/30/2018

EOMONTH("09/25/2018", 1) returns 10/31/2018

EOMONTH("09/25/2018", -1) returns 08/31/2018

If cell A1 contains the date value 9/25/2018, then EOMONTH(A1, 0) returns 9/30/2018