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: 
Sunil_Kenth
Former Employee
Former Employee

Calculating Networkdays using two dates

Hi,

I have a start date and a finish date and i would like to calculate the number of working days between the start date and end date.  At the moment, in the script i have [finish date] - [start date] as Days which give me a count, however this is not excluding the weekend and therefore the number is incorrect.

i have also tried networkdays([finish date], [start date]) as Days but this just gives me a 0 and 1 flags.

Does anyone know the syntax that i need to use?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

networkdays function should be correct, but try first parameter start date, second end date.

View solution in original post

4 Replies
swuehl
MVP
MVP

networkdays function should be correct, but try first parameter start date, second end date.

Sunil_Kenth
Former Employee
Former Employee
Author

Hi Swuehi, thanks for the response.  Can you please clarify, i'm not sure what you mean?

Thanks,

Sunil

Anonymous
Not applicable

I guess he means just to change the order of the parameters: networkdays([start date], [finish date]).

Sunil_Kenth
Former Employee
Former Employee
Author

Ahh i see - yes that worked!  Sometimes youre not able to see the wood from the trees!!

Thanks very much.

Sunil