Forum Discussion
MikeTamoush
Qrew Commander
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
------------------------------
SindyHanner
2 years agoQrew Member
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
------------------------------
------------------------------
Sindy Hanner
------------------------------