Formula to Add Days to Calendar Date

07/31/19 Edited 12/09/19

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?



Popular Tags:


  • Paul NewcomePaul Newcome ✭✭✭✭✭

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


    Give this a try...

Sign In or Register to comment.