NetWorkDays function

[#1]

Hello everyone,

For example, I have 2 dates : DateA = 18/12/2014    and     DateB = 13/01/2015       (in format dd/mm/yyyy)

If I do DateB-DateA, I get 26    which is ok.  (31-18) + 13 = 26

If I do NetWorkDays(DateA,DateB), I expect to obtain 18 because between Thursday 18th and Friday 13rd, there are 4 weekends so 8 weekend days, so I should obtain 26-8 = 18.

But I get 19.

Does NetworkDays include DateA and DateB in the count and so is not equal to :  DateB-DateA - number of Sundays &Saturdays ?

Other question:

I would like to add some days in the holiday field. Those days are fixed every year (25th of December, 1st of January) is there a way to tell QV I want those days as holidays without having to write a list of those days for every year in my Qlikview (25/12/2000, 25/12/2001,...25/12/2015...) ?

Thank you for your help

[Gabriel]

Hi,

I think for simplicity it's best to include Year or you'll get to a stage of nesting variables to accommodate for current year.

[Anonymous]

See this:

http://community.qlik.com/docs/DOC-5741