Add Years

This function adds a specific number of years (for example, 2) to a timeline with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to add 2 years to the 05/03/22 (5 March, 2022) date. After you use the ADDYEARS() function to add 2 years to the 05/03/22 date, it performs the addition and then returns the 05/03/24 (5 August, 2024) date.

You can use the ADDYEARS function as follows:

To use the ADDYEARS function:

1. Click in the smart selector to display the Search box.

2. In the Search box, enter addyears to display the ADDYEARS function.

3. In the list, select the ADDYEARS function to display it with the date, format, and years parameters.

4. In the ADDYEARS function, click click Date to display the Search box.
5. In the Search box, enter static to display the Static function.

6. In the list, select the Static function to display it with the value and the String parameters.
7. In the Static function, click the value parameter and then enter a date (for example, 05/03/22 or 05/03/2022) in dd/mm/yy or dd/mm/yyyy format.

8. In the ADDYEARS function, click the format parameter and then enter dd/mm/yy in the place of the format parameter.

9. In the ADDYEARS function, click the years parameter to display the Search box.
10. In the Search box, enter static to display the Static function.

11. In the list, select the Static function to display it with the value and the Integer parameters.
12. In the Static function, click the value parameter and then enter a value (for example, 2) that you want to add to the earlier defined date (05/03/22).