Solved

# Excel Formula NETWORKDAYS

Posted on 2003-02-19
Medium Priority
631 Views
Looking for a solution that will allow the cell result to be blank. alot of my users don't fill in the offered date.

Open - Offered - Startdate - workdays to fill

02/05/03  blank   blank    -26896 (need the result blank)

=NETWORKDAYS(I6,J6,Holidays!A1:A8)

Thanks AG
0
Question by:angarza85225
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 43

Expert Comment

ID: 7984144
if I have understood correctly,

=if(or(i6="",j6="","",networkdays(i6,j6,Holidays!A1:A8)

should do it (i.e. only show networkdays() if column I & J are filled not blank.

Steve
0

Author Comment

ID: 7984594
It must be missing a parenthesis, i have tried several combinations but cannot close the argument. my error message is

You formula is missing a parenthesis--) or (. check the formula then add the parenthesis in the appropriate place.
0

LVL 1

Accepted Solution

Howler_Fish earned 400 total points
ID: 7985249
I think the formula dragon-it wanted to type was:

=if(or(i6="",j6=""),"",networkdays(i6,j6,Holidays!A1:A8))

HF
0

LVL 43

Expert Comment

ID: 7985941
Sorry, that was a midnight typo :-) (not that I don't make them all day...)

thanks for correcting HF, was that what you were tying to do anyway angarza85225?

the command is or(argument,argument) and if either argument is true then OR returns true so if either i6 r j6 is empty then return blank otherwise return your networkdays formula.

Steve
0

Author Comment

ID: 7987418
Thanks to Howler Fish 1st place. Honorable mention to dragon-it. you are the best in the biz!  AG
0

LVL 43

Expert Comment

ID: 7987529
Er excuse me but that was a minor typo, pardon me for trying to help you...

Steve
0

LVL 1

Expert Comment

ID: 7990414
dragon-it,
See here

http://www.experts-exchange.com/Applications/MS_Office/Q_20523127.html

kb
Experts Exchange Moderator
0

LVL 43

Expert Comment

ID: 7992453
I was only whinging a bit, not asking for points from anyone!! :-)

But never say no...

thanks v.much

Steve
0

LVL 22

Expert Comment

ID: 7997719
So, Steve. When the heck are ya gonna pick 'em up?

http://www.experts-exchange.com/Applications/MS_Office/Q_20523127.html
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
###### Suggested Courses
Course of the Month11 days, 22 hours left to enroll