Weekdaysub - Count end date
Hello, I'm trying to calculate the number of weekdays in a range but don't want the count to stop the day before the end date. Example date ranges: 9/16-9/30 has 11 weekdays (starts on Friday ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI think you need to add on an extra day if the last day is not on a weekend.
WeekdaySub([Pay Period End Date],[Pay Period Start Date])
+
If(
DayOfWeek([Pay Period End Date])<>0
and
DayOfWeek([Pay Period End Date])<>6, 1,0)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
WeekdaySub([Pay Period End Date],[Pay Period Start Date])
+
If(
DayOfWeek([Pay Period End Date])<>0
and
DayOfWeek([Pay Period End Date])<>6, 1,0)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------