Jan 20 2023 03:52 AM
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?
Jan 20 2023 04:00 AM
=IF(COUNTIF(A2:C2,"Won")=1,NETWORKDAYS(D2,E2),"")
You can try this formula for the data layout of the example.