# Calculate Saturdays/Sundays between two Dates

**URL:** <https://forums.knack.com/t/calculate-saturdays-sundays-between-two-dates/19210>\
**Category:** Get Answers\
**Created:** [April 19, 2025, 12:56am UTC](https://forums.knack.com/t/calculate-saturdays-sundays-between-two-dates/19210 "2025-04-19T00:56:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve14](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Steve14](https://forums.knack.com/u/Steve14)\
**Post date:** [April 19, 2025, 12:56am UTC](https://forums.knack.com/t/calculate-saturdays-sundays-between-two-dates/19210/1 "2025-04-19T00:56:56Z")

</div>

Hi All

I am trying to calculate the number of Saturdays and Sundays between two dates in Knack using a formula. Is this even possible using Knack formulas or would I have to write some javascript code?

Ideally, I would also like to be able to count the number of Public Holidays that fall in the same period and already have another table/object that lists all the public holiday dates.

Thanks in advance for any assistance offered.

Steve

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [April 20, 2025, 12:54am UTC](https://forums.knack.com/t/calculate-saturdays-sundays-between-two-dates/19210/2 "2025-04-20T00:54:48Z")

</div>

Hi Steve

Whenever I’ve had a similar challenge I’ve always Googled for Excel solutions since most of the equation expressions are similar.

Hopefully, this video will help you [Watch “How to Count a Specific Day of the Week Between Two Dates | How many Fridays?” on YouTube](https://youtu.be/ljIAKAmgQDI?si=Ep3T1r1UBdk4zqK9) .

Regards  
Dean

---

<div class="post-metadata">

**Author:** ![Hugo](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/hugo/32/4068_2.png) [@Hugo](https://forums.knack.com/u/Hugo)\
**Post date:** [April 22, 2025, 7:12am UTC](https://forums.knack.com/t/calculate-saturdays-sundays-between-two-dates/19210/3 "2025-04-22T07:12:46Z")

</div>

Hi Steve,  
can you have a formula to count the days between the two dates, another to count the working days using netWorkDays and minus one from the other to get the weekend days?  
And for calculating public holidays, look at this post: [Bank Holiday calc with Calendar Days](https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110)  
Let me know if you need a hand.  
Hugo