dchaney
Well-known Member
- Joined
- Jun 4, 2008
- Messages
- 732
- Office Version
- 2016
- Platform
- Windows
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
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