Home

Why IF & NETWORKDAYS function not working?

%3CLINGO-SUB%20id%3D%22lingo-sub-740227%22%20slang%3D%22en-US%22%3EWhy%20IF%20%26amp%3Bamp%3B%20NETWORKDAYS%20function%20not%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740227%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20count%20how%20many%20working%20days%20in%20between%20two%20dates%2C%20but%20I%20don't%20want%20the%20formula%20to%20return%20any%20value%2C%20if%20one%20of%20the%20dates%20is%20missing.%20This%20is%20because%20my%20data%20is%20incomplete%20and%20I%20want%20to%20average%20out%20the%20amount%20of%20dates%20something%20takes.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3EAssigned%20project%3A%2005%2F05%2F2019%3C%2FP%3E%3CP%3ECompleted%20project%3A%2010%2F06%2F2019%3C%2FP%3E%3CP%3EI%20tried%20multiple%20options%20but%20no%20avail%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(OR(ISBLANK(J13)%2CISBLANK(K13))%2C%22%22%2C%20NETWORKDAYS(K13-J13))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3DOR((ISBLANK(Z2)%2CISBLANK(AJ2)%2C%22%22)%2C(NETWORKDAYS(Z2%2CAJ2)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740227%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740250%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20IF%20%26amp%3Bamp%3B%20NETWORKDAYS%20function%20not%20working%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740250%22%20slang%3D%22en-US%22%3EYou%20expect%202%20possible%20results%3A%3CBR%20%2F%3E1.%20Number%20of%20workdays%20between%202%20dates%3B%20or%3CBR%20%2F%3E2.%20Empty%20text%20(%E2%80%9C%E2%80%9D).%3CBR%20%2F%3EThus%2C%20your%20first%20formula%20should%20work%20as%20you%20desire%20except%20that%20you%20must%20change%20minus%20sign%20(-)%20to%20comma%20(%2C)%20in%20your%20NETWORKDAYS%20formula.%3C%2FLINGO-BODY%3E
lgome057
Occasional Visitor

I am trying to count how many working days in between two dates, but I don't want the formula to return any value, if one of the dates is missing. This is because my data is incomplete and I want to average out the amount of dates something takes. 

For example: 

Assigned project: 05/05/2019

Completed project: 10/06/2019

I tried multiple options but no avail: 

 

=IF(OR(ISBLANK(J13),ISBLANK(K13)),"", NETWORKDAYS(K13-J13))

 

 =OR((ISBLANK(Z2),ISBLANK(AJ2),""),(NETWORKDAYS(Z2,AJ2)))

 

Thank you for your help!!! 

1 Reply
You expect 2 possible results:
1. Number of workdays between 2 dates; or
2. Empty text (“”).
Thus, your first formula should work as you desire except that you must change minus sign (-) to comma (,) in your NETWORKDAYS formula.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies