NetworkDays #Invalid Operation

Silvia Rangel

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

Paul Newcome

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

Because you are trying to subtract 1 from a blank.

Try moving your IFERROR to encompass the -1 as well.

=IFERROR(NETWORKDAYS(..............................) - 1, "")

Silvia Rangel

@Paul Newcome Of course :-(

It works, thanks!

Paul Newcome

Happy to help! 👍️