Need a formula to add 30 days to a date. Return date cannot land on a weekend

Question

Hi. Whenever I create a task, I need the due date to be automatically set to 30 days in the future. However, the date that is set must not be a weekend day.

I.e. I create the task on July 30. July 30 + 30 days would be August 29. August 29 is a Sunday. The formula within a process builder action needs to adjust the due date to August 30, which is a Monday.

Same idea if due date lands on a Saturday.

Would greatly appreciate any help.

Thanks,

#Formula

Amey Priolkar · Accepted Answer

Hi  Emmanuel Grembo  ,   You can refer:  https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A8tvLSAR   Similar issue has been mentioned on this link.   Hope this helps!

Amey Priolkar · Answer

Of course, you'll have to add 30 days and then check WEEKDAY and then add days accordingly as shown in the link above.

Need a formula to add 30 days to a date. Return date cannot land on a weekend

도움 더 받기