ADDYEARS
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.
Return value
Returns the calculated date.
Examples
ADDYEARS("05/29/2026", -1)Returns 05/29/2025.
Returns 05/29/2028.
Last updated
Was this helpful?