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.
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.
YEAR_ADD (Contract date, 3)
I added 3 years to my contract date.
Please sign in to leave a comment.