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: 
Not applicable

Networkdays and Days Aged Question

I was wondering if someone could give me some examples of formulas I can use to solve my issue:

Example

Issue:  A Work Order is created on 12/1/2014 and closed 12/12/2014.  That is technically 12 days but two of them are weekends which no work gets done.  I want to base my days aged on NetWorkdays if that is possible.

Any ideas would be welcomed.

Thanks,

David

1 Solution

Accepted Solutions
saurabh5
Creator II
Creator II

hi David,

you can use the networkdays function it will give you 10 days,

eg:

=

NetWorkDays(date(F1),date(F2))

where f1 is created date

          f2 is closed date

regards

Saurabh

View solution in original post

1 Reply
saurabh5
Creator II
Creator II

hi David,

you can use the networkdays function it will give you 10 days,

eg:

=

NetWorkDays(date(F1),date(F2))

where f1 is created date

          f2 is closed date

regards

Saurabh