Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Add x Working Days
Can anybody help me out with constructing a formula to add x working days to a date. I am having a brain meltdown trying to get it to work.
I have got as far as creating something that will add 1 working day to a date:
{custrecord_input_date}+
CASE
TO_NUMBER(TO_CHAR({custrecord_input_date},'D'))
WHEN 7 THEN 2
WHEN 6 THEN 3
ELSE 1
END
but I can't get my head round how I would increment the input date by more than a week and still return a working day.
Hope this makes sense.