Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get count of working days between two dates

Hi,

i want to count no. of working days between two dates. kindly help.

1 Solution

Accepted Solutions
ashwanin
Specialist
Specialist

Hi

You can use Network days function to get the same.

=networkdays([start date], [finish date]).

View solution in original post

6 Replies
ashwanin
Specialist
Specialist

Hi

You can use Network days function to get the same.

=networkdays([start date], [finish date]).

Not applicable
Author

Hi Jitendra,

Please use the function: NetWorkDays(from date,to date).


Regards,

Pooja

maleksafa
Specialist
Specialist

there is already a built in function in qlikview which is networkdays to get the working days between two dates.

Not applicable
Author

Hi, can this function be used during a script load?

sunny_talwar

It definitely can be used in the script as well

Best,

Sunny

Taraun
Contributor II
Contributor II

this is a good function, but how can i add days that fall on weekends with it?