Formula to Add Days to Calendar Date

Good Morning!

So I was wondering if it would be possible to have a formula that would add 6 months (183 days) to a cell with a prepopulated date if a certain criteria is met. So managers will get a form and they will pick either "Yes" or No" for "Extend Vendor" and if they say "Yes" I want it to add 6 months to "New Expiration Date". Would that be possible? If so, what formula should I use?

 

Smarthsheet.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!