Investment Studio > Expressions > Functions > Date & Time > EOMONTH

date eomonth(date start_date, integer months)

Returns the last day of the month obtained by offsetting start_date by months.

Automatic type conversion allows the use of a start_date string instead of an explicit date value.

Example

=eomonth(36144, 2)

and (assuming standard US date format settings)

=eomonth("12/15/1998", 2)

both equal 36219, i.e. February 28, 1999.

See also edate, networkdays, workday, yearfrac.