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

date edate(date start_date, integer months)

Returns start_date offset by the specifed number of months.

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

Example

=edate(35961, 2)

and (assuming standard US date format settings)

=edate("6/15/1998", 2)

both equal 36022, i.e. August 15, 1998.

See also eomonth, networkdays, workday, yearfrac.