Autopopulate Date based on contract renewal terms

Ashleigh Bonneville
edited 11/10/20 in Formulas and Functions


I am looking for a formula that would help with calculating a date based on dates and criteria in two other columns.

Here is the scenario:

I have a contract with an expiration date. This contract is auto renewed for a certain number of years (3, 5, 7). I would like to create a column that contains a formula that calculates the expiration date after the auto renewal period is over.

For example, I have a contract that expires on 12/31/2020. It is auto renewed for 3 years. So the final expiration date is 12/31/2023. Is there a way I can get the date column to take the expiration date and add 3 years to it?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!