Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
2 years ago

Counting weekend days in a span of start/end dates

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
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago

    Try this
    ToDays([End Date] - [Start Date])-WeekdaySub([End Date], [Start Date])
    +1



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet
      2 years ago

      I put in start date of 5/24/2023 and an end date of 5/29/2023 and I got a result of 3 with your formula. Shouldn't the result have been 2?



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