Help with IF formula (and maybe (OR) is needed?)

**mgilmore77** · 03-20-2012, 05:27 PM

I really am stumped and am not that great with the IF formulas yet. If anyone can help I would really appreciate it.

This is what I got....

cell D3: date
cell E3: date
cell F3: =IF(OR(ISBLANK(D3),NETWORKDAYS(E3,D3)-1>2,),"No","Yes")

What I need is this.....
If the date in D3 is more than 1 business day after E3, then I need the result to be "Yes"
If the date in D3 is 1 business day difference (or less), then I need the result to be "Yes"
If cell D3 is blank, then I need the result to be "No"

The issue I am facing with the formula I currently have is that if D3 has "3/20/2012" and E3 has "3/16/2012", the result should be NO.
But I am getting a YES even though that is more than 1 business day. the formula does not properly recognize the business days for some reason.

help??

**TMS** · 03-20-2012, 05:33 PM

Looks like you have an extra comma:

cell F3: =IF(OR(ISBLANK(D3),NETWORKDAYS(E3,D3)-1>2,),"No","Yes")

Try:

cell F3: =IF(OR(ISBLANK(D3),NETWORKDAYS(E3,D3)-1>2),"No","Yes")

Regards, TMS

**ConneXionLost** · 03-20-2012, 05:33 PM

NETWORKDAYS excludes weekends (Saturdays and Sundays).

**Fotis1991** · 03-20-2012, 05:39 PM

Ι think, this is giving your request.

=IF(OR(ISBLANK(D3);NETWORKDAYS(E3;D3)-1>1);"No";"Yes")

**mgilmore77** · 03-21-2012, 10:38 AM

Originally Posted by ConneXionLost

NETWORKDAYS excludes weekends (Saturdays and Sundays).

Yeah, this is what I need because I don't want the formula to count Saturday and Sunday as business days. But for some reason the formula I was using was counting the difference between Friday thru Tuesday as 1 business day instead of 2.

**mgilmore77** · 03-21-2012, 10:46 AM

Originally Posted by TMShucks

Looks like you have an extra comma:

cell F3: =IF(OR(ISBLANK(D3),NETWORKDAYS(E3,D3)-1>2,),"No","Yes")

Try:

cell F3: =IF(OR(ISBLANK(D3),NETWORKDAYS(E3,D3)-1>2),"No","Yes")

Regards, TMS

Thanks! : ) Didn't catch that....still isn't coming up with the right result still....still counts Friday to Tuesday as one business day....I think we added the "-1" part before the ">2" part because it was counting Friday itself as a day, so this took that away. But still not getting it.

**mgilmore77** · 03-21-2012, 11:02 AM

Originally Posted by Fotis1991

Ι think, this is giving your request.

=IF(OR(ISBLANK(D3);NETWORKDAYS(E3;D3)-1>1);"No";"Yes")

Appreciate the help so much, thanks!
Unfortunately this still is not fixing the issue....I gotta do some more digging.

**mgilmore77** · 03-21-2012, 11:42 AM

Okay, it appears this is what I needed (one of our Excel gurus finally figured it out):

=IF(D3="","No",IF(NETWORKDAYS(E3,D3)>2,"No","Yes"))

Thanks everyone!