YEAR_ADD() : add years to a date

In a formula-type column, the YEAR_ADD() function displays a date obtained by adding a number of years to a date-type column. It is used to calculate annual deadlines: contract anniversary date, warranty expiration, renewal date.

Syntax

YEAR_ADD(date_column, number_of_years)

Parameters

# Parameter Description

1 date_column The date-type column to which years are to be added.

2 number_of_years The integer number of years to add. Positive to move the date forward, negative to move it backward.

The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.

Examples

Add years to a date

YEAR_ADD($Date, 1)

The column returns the date shifted by one year.

To identify upcoming deadlines, combine YEAR_ADD() with DAY_DELTA_TODAY() on the resulting date.

Go further

MONTH_ADD

The equivalent in months: add a number of months to a date.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.