Hi,

Which is the weekday they don't work? if it's a Friday try this

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<5),--(ISNA(MATCH(ROW(INDIRECT(A1&":"&B1)),C1:C8,0))))

Where a1 and B1 are the start end days and C1 - c8 are any holidays you wabt
to exclude.

Mike

"Darin" wrote:

The networkday function calculates days based on a 5 day work week. I have
staff who work 4 day weeks and would like to calculate net work days based on
the 4 day week.

Any ideas of how to do this.
--
END