it's when you are adding enough to cross 2 weekend...
# general
k
it's when you are adding enough to cross 2 weekends that that formula gets stupid hard.
r
you could possibly do a CASE(TRUNC(#ofdays/7))>=1 THEN SUM((TRUNC(#ofdays/7)*2),#ofdays) you'd get close anyway...