Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Networkdays issue

I need to deduct a numbers of days from a date and not include Sat, Sun.

The date is in the format 2009-08-10 and the number of days is an integer (5, or 7, ...).

My thought was to use the networkworkdays function but for this I need a start, end date which I do not have.

Is there another way to solve this?

Thanks!

1 Solution

Accepted Solutions
prieper
Master II
Master II

Have a look into the FIRSTWORKDAY-function.

HTH
Peter

View solution in original post

2 Replies
prieper
Master II
Master II

Have a look into the FIRSTWORKDAY-function.

HTH
Peter

Not applicable
Author

Works like a charm!

Thanks!