Hi Salesforce community,
Basic formula request here! Looking to automate the Due Date of a newly created Task to be 3 Business Days from Today. Any takers?
Thanks!
Tim
Can you try this
IF(MOD(TODAY() - DATE(1900, 1, 6), 7) > 3, TODAY()+5, (IF(MOD(TODAY() - DATE(1900, 1, 6), 7) = 0, TODAY()+4, TODAY()+3)))
1900, 1, 6 was Saturday so in case you also create a task on Saturday then still the above formula will work bcoz then it will add 4 days to that
when Today is Monday, Tuesday then it will add 3 days, for Wednesday, Thursday, Friday it will add 5 days
Hope this helps,