EOMONTH

Returns a date representing the last day of the month that is the specified number of months before or after the specified date.

Syntax

EOMONTH( Date startDate, Integer months ) → Date

Parameters

startDate

Required. The start date.

months

Required. The number of months before or after startDate.

Remarks

If the specified months value is not integer, it is automatically truncated. If the result is not representable as a date, the function returns the #VALUE! error value.

Example

Formula

=EOMONTH(TODAY(),1)

See Also

Function Reference
DATE Function
EDATE Function