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

This is one continuos statement but I broke it up to accomodate the line
breaks caused by this msg setup.
--
Pops Jackson


"JK" wrote:

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!!!