NetworkDays #Invalid Operation
Hello Community,
Trying to figure out what I am doing wrong here :-(
I have the below formula to calculate the network days it takes for a contractor to submit the project As-Builts from the day of Actual Completion Date. If the corresponding fields have dates in it, it works perfect. But if the fields are empty, I get the #INVALID OPERATION error, even though l have " " for the blanks.... Help?!
Best Answer
-
Because you are trying to subtract 1 from a blank.
Try moving your IFERROR to encompass the -1 as well.
=IFERROR(NETWORKDAYS(..............................) - 1, "")
Answers
-
Because you are trying to subtract 1 from a blank.
Try moving your IFERROR to encompass the -1 as well.
=IFERROR(NETWORKDAYS(..............................) - 1, "")
-
@Paul Newcome Of course :-(
It works, thanks!
-
Help Article Resources
Categories
Check out the Formula Handbook template!