Question
I know how to add a number of days to a field with a formula however, I need to specify business days.
Answer
Kindly try the following formula:
{custbody2}+ CASE TO_NUMBER(TO_CHAR({custbody2},'D')) WHEN 1 THEN 12 WHEN 2 THEN 14 WHEN 3 THEN 14 WHEN 4 THEN 14 WHEN 5 THEN 14 WHEN 6 THEN 14 WHEN 7 THEN 13 END
For reference, here’s the test that I did, assuming that I am adding 10 business days to the date of the transaction:
