EOMONTH (end of month in n months)

<< Click to Display Table of Contents >>

EOMONTH (end of month in n months)

Syntax:

EOMONTH(StartDate, m)

Description:

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

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

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. Digits right of the decimal point are ignored.

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

See also:

EDATE