Formula for number of days between two dates excluding saturday and sunday.
here {custrecord1} is start date and {custrecord2} is the end date . assumption start date is less than end date.
Formula=
(CASE WHEN {custrecord1} IS NULL OR {custrecord2} IS NULL THEN NULL ELSE (TRUNC({custrecord2}) – (CASE WHEN TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘7’ THEN TRUNC({custrecord1}) + 2 WHEN TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘1’ THEN TRUNC({custrecord1}) + 1 ELSE TRUNC({custrecord1}) END)) + 1 – (FLOOR((TRUNC({custrecord2}) – (CASE WHEN TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘7’ THEN TRUNC({custrecord1}) + 2 WHEN TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘1’ THEN TRUNC({custrecord1}) + 1 ELSE TRUNC({custrecord1}) END) + TO_CHAR(TRUNC( CASE WHEN TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘7’ THEN TRUNC({custrecord1}) + 2 WHEN TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘1’ THEN TRUNC({custrecord1}) + 1 ELSE TRUNC({custrecord1}) END), ‘D’) – 1) / 7) * 2) – CASE WHEN TO_CHAR(TRUNC({custrecord2}), ‘D’) = ‘7’ THEN 1 WHEN TO_CHAR(TRUNC({custrecord2}), ‘D’) = ‘1’ THEN 1 ELSE 0 END END) – (case when TO_CHAR(TRUNC({custrecord2}), ‘D’) = ‘1’ then 0 else 1 end) + ((case when ((TO_CHAR(TRUNC({custrecord2}), ‘D’) = ‘1’ AND TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘1’) OR (TO_CHAR(TRUNC({custrecord2}), ‘D’) = ‘7’ AND TO_CHAR(TRUNC({custrecord1}), ‘D’) = ‘7’)) then 1 else 0 end) )