Add week days only to a date

[regowins]

Hi,

How do I add only week days to a date. I am trying to set a due date but I only want business days. For example, if I do date(current_date + 10) as due_date gives me calendar days. I want the due date to show 10 week days from the current date.

Thanks!!

[swuehl · Accepted solution]

Try LastWorkDate() function:

lastworkdate(today()+1, 10)

will add 10 working days to today (not counting today itself).

[regowins]

Great, Thanks!