IF statement and Network days

[Guest]

I'm using an IF statement to let me know if a shipment arrived ontime.
However, I'd like it to count only business days - not calendar days. I
already have a NETWORKDAYS sheet that lists all the weekends and my holidays
so I thought it would be easiest to use that. However, I can't get both the
IF & NETWORKDAYS statements to work together.
Anyone have an idea??? I'm using MS Excel 2003.

thanks, Kim (data examples below)

A B C
supposed actual
to ship ship ontime
1/3/07 1/10/07
2/2/07 1/30/07 1
1/26/07 1/27/07 1

The IF statement that I use in column C (Ontime):
=IF(A2<=(B2+2),1,"")

 

[Guest]

=IF(NETWORKDAYS(A1,B1)<2,1,"")

 

[Guest]

That does work for most of the lines but it's not recongizing the the fact
that I have a 2 day late allowance. If the order was supposed to ship on
2/14 but didn't ship until 2/16 - it would still be considered ontime due to
this rule.

Also, where do I plug in my holiday list?