TO_CHAR( (CASE WHEN ROUND(NVL({timeremaining}, 0) / 8) <= 0 THEN {today} ELSE {today} + FLOOR((ROUND(NVL({timeremaining}, 0) / 8) + CASE WHEN TO_CHAR({today}, ‘D’) IN (‘7’, ‘1’) THEN 1 ELSE 0 END) / 5) * 7 + MOD(ROUND(NVL({timeremaining}, 0) / 8) + CASE WHEN TO_CHAR({today}, ‘D’) IN (‘7’, ‘1’) THEN 1 ELSE 0 END, 5)+ CASE WHEN TO_CHAR({today} +… Continue reading SQL formula Add dynamic number of days to a static date or today date excluding non working days Saturday or Sunday