Counting weekend days in a span of start/end dates

Question

I am trying to write a formula that provides a number of weekend days in a span of a start to end date. e.g from 4/1/2023 to 4/23/2023 there are 8 weekend days. I want a formula that solves this for any Start and End date.

------------------------------
George Bramhall
------------------------------

MarkShnierYou · Answer

Try thisToDays([End Date] - [Start Date])-WeekdaySub([End Date], [Start Date])+1------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Sign up

Login to the community