Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

week days!!! Help!!

Hi everyone;

I need to get the week days but without count the saturdays and sundays, there are exists some function for this? can you help boys?

Regards!!!!

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI

Try like this

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

thanks work it!!!!

Regards!!!