Date Range Exclude Sunday AND 1/2 Saturday

Ask for Help
1

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.

2

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?

3

Exactly!

4

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.

4 Likes