Multiple IF(AND criteria with NETWORKDAYS?

Jen Castillo

I am trying to use NETWORKDAYS with two criteria: whether there was a value in [PO Issues] + whether or not it was checked/addressed in [PO Issue Resolved].

My current formula is:

=IFERROR(IF(AND([PO Issue Resolved]@row = "false", ([PO Issues]@row <> "", NETWORKDAYS([Quality Control End Date]@row, [Receiving Completed Date]@row)), "")

What am I doing wrong?

Kelly Moore

Hey @Jen Castillo

Try this

=IFERROR(IF(AND([PO Issue Resolved]@row = 0, [PO Issues]@row <> ""), NETWORKDAYS([Quality Control End Date]@row, [Receiving Completed Date]@row)), "")

Will this work for you?

Kelly

Kelly Moore

Hey @Jen Castillo

Try this

=IFERROR(IF(AND([PO Issue Resolved]@row = 0, [PO Issues]@row <> ""), NETWORKDAYS([Quality Control End Date]@row, [Receiving Completed Date]@row)), "")

Will this work for you?

Kelly