# 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:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [December 14, 2022, 2:07am UTC](https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717/1 "2022-12-14T02:07:51Z")

</div>

I understand now to have a Date Range using the:

> ROUND(end date - start date)

But what if i need the Date Range between two dates but exclude the Sunday and Half day of Saturday.  
Meaning , the working day is Monday to Friday AND half day of Saturday. 5.5/week.

---

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

</div>

Let me state your question in my own words, and tell me if my understanding is correct.

I have a start date and an end date, and I want to count the number of days between each. I want to exclude Sundays, and only count Saturdays as half a day.

Correct?

---

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [December 14, 2022, 2:32am UTC](https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717/3 "2022-12-14T02:32:09Z")

</div>

Exactly!

---

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