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
WeekDay Sub subtracts and counts weekdays in the interval, but not including the last day. So it is not counting your last day. Your October one doesn't matter because the last day is Saturday, but in September it matters.
"WeekdaySub (Date d2, Date d1)
Description: Returns the number of weekdays in the interval starting with d1 and ending on the day before d2"
I think if this may work, but untested:
WeekdaySub([Pay Period End Date] +Days(1), [Pay Period Start Date])
------------------------------
Mike Tamoush
------------------------------
"WeekdaySub (Date d2, Date d1)
Description: Returns the number of weekdays in the interval starting with d1 and ending on the day before d2"
I think if this may work, but untested:
WeekdaySub([Pay Period End Date] +Days(1), [Pay Period Start Date])
------------------------------
Mike Tamoush
------------------------------
Perfect! Thank you! I was adding a +1 but to the end which made my Oct 11 M-F days.
Sindy Hanner
Sr NOC Operations Support Specialist
Network Operations Control
(469) 603-0939
HDQ-NOC
- This solution worked. I tried adding the +1 but put it after the second date instead of the first. Thank you so much!
------------------------------
Sindy Hanner
------------------------------