networkdays formula

[brianc0428]

I am trying to create a forumula to tell me if the date in C2 is atleas
7 business days before B2. The answer will be in G2. I have attache
the spreadsheet. Thanks in advance.

Bria

Attachment filename: new hire report(fixed).xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62222

 

[Norman Harker]

Hi Brian!

One way:

=NETWORKDAYS(C2,B2)>=7

Or if you want a return other than TRUE or FALSE, use the above as the
condition in an IF function.

NETWORKDAYS is an Analysis ToolPak function and Analysis ToolPak must
be installed and selected as an Addin.

You can use an additional argument that is a range of cells that
contains a list of holidays.

 

[brianc0428]

Thanks..

This is the formula i created but it is not working.
=IF(NETWORKDAYS($C2,$B2,Holidays!$A$1:$A$7)*C2>=B2-7,"Yes","No"

 

[Norman Harker]

Hi Brian!

Try:
=IF(NETWORKDAYS($C2,$B2,Holidays!$A$1:$A$7)*(C2>=B2-7),"Yes","No")

To coerce the Boolean return of C2>=B2-7 to 0, you need the
parentheses.