ADDMONTHS

The ADDMONTHS function adds a number of months to a date.

For example, you can use the ADDMONTHS function to show a contractor's end date at a company.

Syntax

ADDMONTHS(Date, number)

Arguments

The ADDMONTHS function returns a date result.

Additional information

If you want to subtract the number of months from a date, you can use negative numbers in a formula. For example, ADDMONTHS(Amended contract date, -6).

Excel equivalent function

EDATE

Related Anaplan functions

ADDYEARS

Examples

In this example, a Contractor Details module has line items on rows and the Contractors list on columns. Both line items have a date format.

The formula returns the date six months after the contractor's start date. 

If you want to add months and days to a date, you can use additional numbers in your formula. In this example, the formula returns the date six months and 14 days after the contractor's start date.