topic Count Weekend Days in QlikView

Count Weekend Days

Wed, 06 Apr 2011 11:44:25 GMT

Hi,

I have a quick but urgent question. Does anyone know how I could count weekend days. As an example, how could I count the weekend days between StartDate = '2011-04-01' and EndDate = '2011-04-06' which would be 2.

Thanks,

Shane

Count Weekend Days

Wed, 06 Apr 2011 11:57:40 GMT

Hi shanejv,

Calculate the total count of days between the duration (StartDate = '2011-04-01' and EndDate = '2011-04-06' ) and subract with the count of Networkdays.

Count Weekend Days

Thu, 07 Apr 2011 10:30:15 GMT

Thanks for the response.

I achieved an hour difference between two dates (excluding weekends) by doing this:

Thanks,