I have a picklist field on Opportunity called Delivery_Followup__c with the values: 2 Weeks, 3 Weeks, 1 Month.

I have a process builder that creates a task to followup with the customer and we want to set the due date to be Today() + Delivery_Followup__c.

Is there a way to add the weeks/month to the Today() function in a process builder formula?

1 Answer 1


Use the CASE function.

TODAY() + CASE ( Delivery_Followup__c, "2 Weeks", 14 , "3 Weeks", 21 , "1 Month", 30 , 0 )

  • Although 1 month can be anywhere from 28 to 31 days...
    – Adrian Larson
    Aug 25, 2016 at 22:45
  • @AdrianLarson this is acceptable for the most cases, otherwise he would have to deal with a complex formula like search for 'Adding Days, Months, and Years to a Date' here
    – o-lexi
    Aug 25, 2016 at 23:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.