topic QlikSene - Date Difference - exclude Friday and Saturday during Date difference in App Development

QlikSene - Date Difference - exclude Friday and Saturday during Date difference

psenthilbtech — Sat, 16 Nov 2024 19:26:03 GMT

Hi Team,

I have a scenario , where i have to find the date difference between 2 dates.

Ex : Start Date and End Date

Condition - Exclude Friday and Saturday

Regards,

Senthil

Vegar — Wed, 18 Dec 2019 07:54:26 GMT

Maybe this will work?

=Networkdays( [Start Date]+1, [End Date]+1)

EliGohar — Wed, 18 Dec 2019 08:31:55 GMT

@Vegar that worked for me, thanks 🙂