The ADDYEARS function adds or subtracts a specified number of years from a date. This function is commonly used to calculate future or past dates for planning, forecasting, and reporting scenarios.
Syntax
ADDYEARS(date,value)
Arguments
date: The input date. This can also be a measure or reference.
value: The number of years to add or subtract. Use a positive value to add years and a negative value to subtract years.
