1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. 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

ArgumentData typeDescription
DateDateThe date to add months to.
NumberNumberThe number of months to add to the date.

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. 


Shala EngleEric Jones
Contractor start date02/08/202106/09/2021

Contractor end date

ADDMONTHS(Contractor start date, 6)

02/02/202206/03/2022

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.


Shala EngleEric Jones
Contractor start date02/08/202106/09/2021

Contractor end date

ADDMONTHS(Contractor start date, 6) + 14

16/02/202220/03/2022