Formula to Add Days to Calendar Date

Jovani Enriquez

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?

 

Paul Newcome

=IF([Extend Vendor Access]@row = "Yes", [Old Vendor Expiration Date]@row + 183)

 

Give this a try...