Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
regowins
Creator II
Creator II

Add week days only to a date

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!!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try LastWorkDate() function:

lastworkdate(today()+1, 10)

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

View solution in original post

2 Replies
swuehl
MVP
MVP

Try LastWorkDate() function:

lastworkdate(today()+1, 10)

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

regowins
Creator II
Creator II
Author

Great, Thanks!