Network days syntax help

[#1]

hi i am currently stuck with a problem whereby i find no solution myself.

the situation is that i cannot deduct the weeekend days from my total.

i am using the following script without success;

=Sum({<Date2={">=$(=date#(%DatXX_Ölev,'YYYY-MM-DD'))<=$(=date#(%DatXX_Lev,'YYYY-MM-DD'))"},isWeekday={1}>}Date2)

i have attached my example.

anyhelp would be greatly appreciated.

Best

Brad

[Oleg_Troyansky]

Didn't you want to COUNT dates, instead of using SUM?

[tresesco]

Hello Brad,

Though i am not clear about your requirement, there is a function, networkdays() in qv, which excludes weekends with some more flexibility. Have you tried that? And yes, as suggested by Oleg Troyansky, you might want to use count() instead of sum().