For example, you can use the ADDYEARS function to show a customer's contract end date.

ADDYEARS(Date, number)

 Argument Data type Description Date Date The date to add years to. Number Number The number of years to add to the date.

The ADDYEARS function returns a date result.

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

In Polaris, if you use a value of NaN (Not a Number) for the Number argument, the ADDYEARS function returns a blank value.

In the Classic Engine, a value of NaN used with ADDYEARS is equivalent to 0.

EDATE

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

The formula returns the date two years after the customer's contract start date.

 Customer A Customer B Contract start date 01/01/2021 01/06/2021 Contract end date ADDYEARS(Contract start date, 2) 01/01/2023 01/06/2023

If you want to add years and days to a date, you can use additional numbers in your formula. In this example, the formula returns the date one year and seven days after the contract start date.

 Customer A Customer B Contract start date 01/01/2021 01/06/2021 Contract end date ADDYEARS(Contract start date, 1) + 7 08/01/2022 08/06/2022