IF statement and Network days
 

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,"")

IF statement and Network days
 

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


"Kim" wrote:

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,"")

IF statement and Network days
 

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?

"Teethless mama" wrote:

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


"Kim" wrote:

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,"")