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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!