Forum Discussion
Using if statement with Networkdays
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
=IF(COUNTIF(A2:C2,"Won")=1,NETWORKDAYS(D2,E2),"")You can try this formula for the data layout of the example.
