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???

=NETWORKDAYS(A1,B1)-INT((B1-A1)/7)+(WEEKDAY(A1,2)=5)

This formula subtracts 1 for each Fri between A1 and B1.

--
Regards!
Stefi



€žNancy S€� ezt Ã*rta:

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???