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
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 .
Regards
Dean
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
Let me know if you need a hand.
Hugo