Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using NETWORKDAYS | Excel Discussion (Misc queries) | |||
NETWORKDAYS | Excel Worksheet Functions | |||
#NAME when using NETWORKDAYS | Excel Discussion (Misc queries) | |||
Networkdays? | Excel Discussion (Misc queries) | |||
NETWORKDAYS | Excel Worksheet Functions |