https://netsuiteprofessionals.com logo
Title
k

KevinJ of Kansas

07/25/2019, 9:52 PM
it's when you are adding enough to cross 2 weekends that that formula gets stupid hard.
r

Ricardo

07/25/2019, 11:35 PM
you could possibly do a CASE(TRUNC(#ofdays/7))>=1 THEN SUM((TRUNC(#ofdays/7)*2),#ofdays) you'd get close anyway...