N
Nancy S
I need to know the # of workdays between 2 dates (I know of the NETWORKDAYS
function).
The problem is that if one of the days in that range falls on a Fri, I need
to subtract 1 more day from the workweek.
It appears the WEEKDAY function does not allow you to consider a range of
dates, only a specific date.
One option I thought of is including all Fri dates in the holiday field when
building the formula so it will exclude those dates.
This will be a bit time consuming. Any other ideas???
function).
The problem is that if one of the days in that range falls on a Fri, I need
to subtract 1 more day from the workweek.
It appears the WEEKDAY function does not allow you to consider a range of
dates, only a specific date.
One option I thought of is including all Fri dates in the holiday field when
building the formula so it will exclude those dates.
This will be a bit time consuming. Any other ideas???