Prev Previous Post   Next Post Next
  #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!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using NETWORKDAYS mandy Excel Discussion (Misc queries) 9 May 2nd 07 10:03 AM
NETWORKDAYS Connie Martin Excel Worksheet Functions 3 July 28th 06 07:52 PM
#NAME when using NETWORKDAYS Amy Excel Discussion (Misc queries) 4 June 29th 06 10:17 PM
Networkdays? Steve Excel Discussion (Misc queries) 6 August 6th 05 01:53 AM
NETWORKDAYS sinbad Excel Worksheet Functions 2 July 19th 05 12:32 PM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"