Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lee1
Contributor
Contributor

count the number of weekends between 2 dates

Hello

Can you help me Plz 🙂

I want to calculate the number of weekends between 2 dates

1 Solution

Accepted Solutions
sunsun566
Contributor III
Contributor III

Hi

Count({< Weekend = {"Saturday", "Sunday"}, Date =  {'>=$(=Date($(vStartDate)))<=$(=Date($(vEndDate)))'}  >}  distinct Date)

Hope it helps

View solution in original post

1 Reply
sunsun566
Contributor III
Contributor III

Hi

Count({< Weekend = {"Saturday", "Sunday"}, Date =  {'>=$(=Date($(vStartDate)))<=$(=Date($(vEndDate)))'}  >}  distinct Date)

Hope it helps