Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do cumputation with working days

Hello,

I want to do computations between two dates. For example:

(monday)  01.02.16   -   29.01.16  (friday).

Unfortunately the system is giving me back the result of 3 in fact that it count the weekend in between. I want to see 1 as an result if I think in working days.

Is there as easy option to tell the system to ignore sat und sun in the computation?  or the other way around on respect days from monday fto friday?

Thx for help

Heiko

2 Replies
sunny_talwar

Try this:

NetWorkDays(StartDate, EndDate)

In your case -> NetWorkDays(MakeDate(2016,1,29), MakeDate(2016,2,1))

Not applicable
Author

Hello Sunny , thx for your great help.