The Planned Shipping Date should be calculated as: Current Due Date to Customer – 10 Working days

Formula is: {custcol_jj_ee_duedate} – CASE WHEN TO_NUMBER(TO_CHAR({custcol_jj_ee_duedate}, ‘D’)) = 1 THEN 13 — Sunday WHEN TO_NUMBER(TO_CHAR({custcol_jj_ee_duedate}, ‘D’)) = 7 THEN 12 — Saturday ELSE 14 — Other weekdays END How It Works Sunday (1): Subtract 13 days Saturday (7): Subtract 12 days Monday to Friday (2–6): Subtract 14 days