ADDYEARS
The ADDYEARS function allows you to add or subtract a specified number of years to a given date.
Syntax
ADDYEARS(date,value)
//adds the given number of years to the date and returns it
Arguments
date - Date in any format. Required. This can also be a measure or a node reference.
value - Number of years to be added to the date. Required. Use a negative number to subtract the years from the given date.
Return Value
Date.
Example

Last updated
Was this helpful?