This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi, what would a formula be to set duedate to be the friday of the week the invoice was created. I have the workflow working etc, just struggling a bit with the formula to set the field. Thanks!

<https://stackoverflow.com/questions/54637904/calculated-due-date-that-excludes-weekends> Not the exact answer but might be helpful

I am on mobile so I can't test but something like this should work `{today} + (TO_CHAR({today}, 'D') - 6)`

If invoiced on a Saturday, it would be be due the previous day, unless you add a check for that.

Excellent thanks i will try and get back to you <@U29QCJQF3> 