I would have guessed that you wanted the holidays!a1:a10 in each portion:

=IF(B8=A8,NETWORKDAYS(A8,B8,holidays!a1:a10)-1,
NETWORKDAYS(A8,B8,holidays!a1:a10)+1)
(all one cell)

Hausma wrote:

Dave, thanks for the quick response. I'm still having trouble getting the
formula correct. I'm am trying to determine how many on time, early and late
shipments we have. This formula seemed to give me the information that I
needed but then I realized that it was treating holidays as workdays also.
So I need to exclude these 10 days. I have entered them on a different sheet
and pointed to this sheet but I must be entering something incorrectly
because I get a paraenthesis error or #value

=IF(B8=A8,NETWORKDAYS(A8,B8)-1,NETWORKDAYS(A8,B8)+1,NETWORKDAYS(A8,B8,HOLIDAYS! A1:A10)
Am I doing this correctly?

Hausman

"Dave Peterson" wrote:

Put those 10 holidays in A1:A10 of a different sheet.

Then look at the help for =networkdays().

You'll see a sample formula like:

=NETWORKDAYS(A2,A3,A4:A6)

You'd point at that other sheet:
=NETWORKDAYS(A2,A3,sheet2!A1:A10)



Hausma wrote:

I'm not sure how to exclude holidays using this formula to count the number
of working days between two dates. I want to exclude 10 specific holidays
which would normally be considered work days.

Hausma

"Alex Delamain" wrote:


Try this one then


=IF(B8=A8,NETWORKDAYS(A8,B8)-1,NETWORKDAYS(A8,B8)+1)


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=265428



--

Dave Peterson


--

Dave Peterson