Help with #VALUE when code is in the cell

[dchaney]

Hello All,

I am working on a spreadsheet to populate the number of days (Minus weekends) that it takes to resolve an issue. The problem I am having is that if the Open date and the Resolved date are both blank (Minus the formula that populates the cell) I get #VALUE. Below is the current code I am using

=IF($D4,NETWORKDAYS($D4,IF($E4="",TODAY(),$E4))-SIGN(NETWORKDAYS($D4,IF($E4="",TODAY(),$E4))),"")

Column D = Open Date
Column E = Resolved Date
This formula is in Column F

 

[Dryver14]

what formula generates the date as i can not get this formula to give me a #VALUE ?

 

[stilesbn]

What would you like it to say if both D4 and E4 are blank?

 

[dchaney]

Column D contains =IF('Time - Week 1'!$I3 > 1,'Time - Week 1'!$I3,"")
Column E contains =IF('Time - Week 1'!$H3 > 1,'Time - Week 1'!$H3,"")

So when =IF($D3,NETWORKDAYS($D3,IF($E3="",TODAY(),$E3))-SIGN(NETWORKDAYS($D3,IF($E3="",TODAY(),$E3))),"") looks at these cells I assume they do not appear empty so it tosses the #VALUE error. I just can not figure out how to make it show nothing unless there is an actual date in column D and E.

I am trying to automate a spreadsheet that takes me hours to update each month. My team fill in this sheet on a daily basis, and I am trying to get this data to reflect on my master sheet so I can save time.

 

[Dryver14]

It's long but seems to work

=IF(ISERROR(IF($D4,NETWORKDAYS($D4,IF($E4="",TODAY(),$E4))-SIGN(NETWORKDAYS($D4,IF($E4="",TODAY(),$E4))),"")),"",IF($D4,NETWORKDAYS($D4,IF($E4="",TODAY(),$E4))-SIGN(NETWORKDAYS($D4,IF($E4="",TODAY(),$E4))),""))

 

[dchaney]

Thanks a lot for your help, works perfect for my needs