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 AsBuilts 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!