topic Re: Days counts between two dates. in QlikView

Days counts between two dates.

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a start and end date and I wish to find how many week days(Mon-Friday) and week end (Sat-Sun) were between the dates.

for example :

If Start_date=17.12.2014(Wed)

End_date = 22.12.2014(Monday) , I want to know the how many weekdays and week end fall between them.

Both the dates exclusive.

desired output:

Number of weekdays Number of Weekenddays

2( for eg.Thu,Friday) 2(Sat,Sun)

Can someone help me here?

Thanks in advance

Re: Days counts between two dates.

prat1507 — Tue, 20 Jun 2017 12:44:22 GMT

Use =NetWorkDays('2017-06-01',(today())) for counting weekdays

and subtract it from the total no. of days to count the weekends.

Re: Days counts between two dates.

avinashelite — Tue, 20 Jun 2017 12:45:58 GMT

Try like this

NetWorkDays(StartDate,EndDate)

Re: Days counts between two dates.

sunny_talwar — Tue, 20 Jun 2017 12:47:33 GMT

May be this

WeekDays

NetWorkDays(Start_date+1, End_date -1)

WeekEnds

End_date - Start_date - 1 -NetWorkDays(Start_date+1, End_date -1)

Re: Days counts between two dates.

Tue, 20 Jun 2017 17:39:46 GMT

Hi Pratyush,

Can you give me example for weekend counting.

Re: Days counts between two dates.

Tue, 20 Jun 2017 17:46:05 GMT

Hi Sunny,

This works perfectly!!. .Thanks for coming back .

Can you please explain the logic ?

Thanks..

Re: Days counts between two dates.

Tue, 20 Jun 2017 17:48:32 GMT

How do I mark this thread as Resolved?

Re: Days counts between two dates.

sunny_talwar — Tue, 20 Jun 2017 17:55:03 GMT

Look here

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Days counts between two dates.

sunny_talwar — Wed, 21 Jun 2017 02:18:26 GMT

Which of the two expressions are you not able to understand? First one is a function available in QlikView and Qlik Sense

networkdays - script and chart function ‒ Qlik Sense‌

While other is just doing Total Difference - Working Days.