# Date Range Exclude Sunday AND 1/2 Saturday

**URL:** <https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717>\
**Category:** Ask for Help\
**Created:** [December 14, 2022, 2:07am UTC](https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717 "2022-12-14T02:07:51Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [December 14, 2022, 2:49am UTC](https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717/4 "2022-12-14T02:49:48Z")

</div>

Okay, take a look at the below:

To get what you need, you’ll need to modify it slightly.  
The main change will be with the if-then-else (isWorkingDay) column. Instead of returning true, it will need to return a number based on the weekday. So the if-then-else would be:

- if svStartDate is empty, then null
- if svEndDate is empty, then null
- if ActualDate is after svEndDate, then null
- if Weekday is less than 2, then null
- if Weekday equals 7, then 0.5
- else 1.0

And then your rollup should do a sum of the if-then-else to get a total.

---

_[View the full topic](https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717)._