In a formula column, the YEAR_ADD () function adds a year to a date which is the addition of a date from a date column and an X number of years.

Formula

YEAR_ADD (Date column, 3)

The first parameter is the exact name of a date column.

The second parameter is an integer which corresponds to the number of years I want to add. This number can be positive or negative.

Example

YEAR_ADD (Contract date, 3)

I added 3 years to my contract date.