# Work days in a Month / Quarter

**URL:** <https://community.glideapps.com/t/work-days-in-a-month-quarter/62360>\
**Category:** Ask for Help\
**Created:** [June 1, 2023, 12:51pm UTC](https://community.glideapps.com/t/work-days-in-a-month-quarter/62360 "2023-06-01T12:51:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [June 1, 2023, 12:51pm UTC](https://community.glideapps.com/t/work-days-in-a-month-quarter/62360/1 "2023-06-01T12:51:40Z")

</div>

Has anyone figured out a simple way to calculate how many work-days are in a week/month/quarter?

No need for holidays (but that would be nice 🙂 )

I have a feed and I want to calculate activity and I need a denominator - e.g. work days.

TIA

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 1, 2023, 1:05pm UTC](https://community.glideapps.com/t/work-days-in-a-month-quarter/62360/2 "2023-06-01T13:05:56Z")

</div>

Yeah, I do this a lot.

My method involves creating a Helper Table with enough rows to cover the entire period that I’m interested in. Then use a bit of date math to populate each row with an incrementing date, starting from some arbitrary date. Calculate the `Weekday` number for each date, use a bit of if-then-else logic to determine which are workdays, then rollup to get a count. If you want to factor public holidays in, then all you need is a separate table with a list of public holiday dates, build a single relation to that, and use the state of the relation in the if-then-else logic.

If this approach interests you, I’m sure I have a video somewhere that walks through it step by step.

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [June 1, 2023, 1:09pm UTC](https://community.glideapps.com/t/work-days-in-a-month-quarter/62360/3 "2023-06-01T13:09:08Z")

</div>

I am interested. Thanks Darren

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 1, 2023, 1:38pm UTC](https://community.glideapps.com/t/work-days-in-a-month-quarter/62360/4 "2023-06-01T13:38:34Z")

</div>

This one shows how to calculate the number of working days between two dates. The premise was for calculating how many days of leave an employee might be taking, but the technique is exactly as I described above.