case when {closedate}<{trandate} then 

null 

else

floor({closedate}-{trandate})-floor(({closedate}-{trandate})/7)*2

- case when TO_CHAR({trandate},'D')> TO_CHAR({closedate},'D') 

then 2 else 0 end

end