How to write and IF AND statement with a NOW date and NETWORKDAYS

[Tpulcino]

I'm trying to show how many buisiness days are remaining in a project based on a NOW date formual. I have this working correctly by using the following formual:

IF(Table1[[#This Row],[Target_End_Dt]]="","",NETWORKDAYS($AJ$1,Table1[[#This Row],[Target_End_Dt]]))

The second piece I'm trying to incorporate is when cell G2 is = to "Closed" return nothing ("").

Meaning when my project is in a closed status, I no longer want to show the number of business days it will take to complete the project.

thanks

[daddylonglegs]

Try using an OR at the start, e.g.

=IF(OR(Table1[[#This Row],[Target_End_Dt]]="",G2="Closed"),"",NETWORKDAYS($AJ$1,Table1[[#This Row],[Target_End_Dt]]))

[Tpulcino]

Worked perfect! Thank you