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