asked on

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

Steve Knight

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

angarza85225

ASKER

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.

ASKER CERTIFIED SOLUTION

Howler_Fish

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve Knight

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

angarza85225

ASKER

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

Steve Knight

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

Steve

kodiakbear

dragon-it,
See here

https://www.experts-exchange.com/questions/20523127/Points-for-dragon-it.html

kb
Experts Exchange Moderator

Steve Knight

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

But never say no...

thanks v.much

Steve

Anne Troy

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

https://www.experts-exchange.com/questions/20523127/Points-for-dragon-it.html