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