Thread: networkdays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jk jk is offline
external usenet poster
 
Posts: 109
Default networkdays

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