Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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

7 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?

locori
Contributor III
Contributor III

Hello, Is there a solution for calculating the number of working days between two dates without weekends and holidays contagemdedias. Please help