Biff, your formula worked!
Maybe I made a typo with Pop's formula because they appear to be the same
(haven't tracked down the problem yet..)

Thanks guys! You rock!

"T. Valko" wrote:

=NETWORKDAYS(DateFrom,WeekEnd, Holiday)-J12-J13

Is there a problem with the formula? What's in J12 and J13?

You don't need to use conditional formatting to do that. You can use an
error trap directly in the formula that will leave the cell blank:

=IF(ISERROR(NETWORKDAYS(DateFrom,WeekEnd,
Holiday)-J12-J13),"",NETWORKDAYS(DateFrom,WeekEnd, Holiday)-J12-J13)

Biff

"JK" wrote in message
...
I could use some help with the NETWORKDAYS function in Excel.
First, I want the formula to calculate the number of work-days between two
dates and subtract the holiday's I have hidden in another worksheet. Then,
I
want it to subtract two other cells (vacation days, sickdays).

This is what I have:
=NETWORKDAYS(DateFrom,WeekEnd, Holiday)-J12-J13

Lastly, I would like to incorporate the IF ISERROR into the formula so
that
anyone using this template without the Analysis ToolPak Addin installed
receives TRUE or FALSE instead of #NAME. That way, I could use a
conditional
format to change the font to white if true or false is displayed. For some
reason that doesn't work with #NAME.

Thanks!!!