Using if statement with Networkdays

Copper Contributor

I'm trying to write a formula where if one of my columns states 'Won' then an another column it will work out the number of working days between to dates. 

 

Can someone help me please?

1 Reply

@Kristie_Ullett 

=IF(COUNTIF(A2:C2,"Won")=1,NETWORKDAYS(D2,E2),"")

You can try this formula for the data layout of the example.

networkdays.JPG