Date Range Exclude Sunday AND 1/2 Saturday

Ask for Help
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