Difference between days excluding weekends and holidays?

[qlikuser222]

Hi,

I want to get the difference between start date and end date for a process excluding weekends and holidays.

Can anyone please help me ?

[Chanty4u]

chk dis

Exclude Weekends (Friday and Saturday) and non working hours from Dates Difference

Re: Finding working days excluding weekend and holidays

[Anonymous · Accepted solution]

Have al ook at the NetworkDays() function.

Here is the Help entry for it from the QV Desktop Help :

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.

Examples:

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

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

[Colin-Albert]

The networkdays() function will do this. You need to provide the start date, end date and a comma separated list of holiday dates.

You can use the concat() function to generate the comma separated list of holidays in a separate table and then p[eek the result into a variable.