Qlikview - calculate number days between two dates except sunday

[#1]

Hi,

how can I calculate number of days between two dates except sunday. I want to calculate number of days between

date1 = 17-08-2016;

date2 = 3-09-2016;

I try

NetWorkDays(date1, date2)

but include include only working days... and I want to include working days and Saturday...

Any idea?

[swuehl]

Just add the number of saturdays to the Networking days:

¿How to count Saturdays in date range?

(or calculate the total amount of calendar days and modify the expression to subtract the number of sundays).

[settu_periasamy · Accepted solution]

Look this also.

Networkdays with saturday

[#4]

i can't open qvf file in qlikview

[swuehl]

If you are referring to the thread I've linked to, there are also QVW files attached to the thread and in addition the expression to calculate number of saturdays in a period in text form.

[#6]

OK, thanks... I found QVW file