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

## Arguments

 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).

## Calculation engine functionality differences

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

## Examples

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

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.