NetWorkDays function in expression

[ahmedwank]

Hi all,

when i use NetWorkDays function in expression to calculate the difference of working days i always have 1 more.

for exemple in my table here bellow i should have 1 because there is only 1 day between monday and friday (whithout the weekend) and i have 2. That's the same story for all my dates, i have always 1 daye extra.

i don't understand why ?

Thanks for your help

[Vegar]

The definition of the networkdays function is as follows:

The networkdays function returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holiday.

NetWorkdays for Friday-Monday will as designed return 2 days and not 1.

[Vegar · Accepted solution]

To get your desired no of days you could subtract one day.
=networkdays(start_date, end_date) -1

Read more about the function here: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...