Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 648
  • Last Modified:

Excel Formula NETWORKDAYS

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
angarza85225
Asked:
angarza85225
1 Solution
 
Steve KnightIT ConsultancyCommented:
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
 
angarza85225Author Commented:
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
 
Howler_FishCommented:
I think the formula dragon-it wanted to type was:

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


HF
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Steve KnightIT ConsultancyCommented:
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
 
angarza85225Author Commented:
Thanks to Howler Fish 1st place. Honorable mention to dragon-it. you are the best in the biz!  AG
0
 
Steve KnightIT ConsultancyCommented:
Er excuse me but that was a minor typo, pardon me for trying to help you...

Steve
0
 
kodiakbearCommented:
dragon-it,
See here

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

kb
Experts Exchange Moderator
0
 
Steve KnightIT ConsultancyCommented:
I was only whinging a bit, not asking for points from anyone!! :-)

But never say no...

thanks v.much

Steve
0
 
DreamboatCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now