Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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.
0