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.

ADDYEARS("05/29/2026", 2)

Returns 05/29/2028.