Nesting Networkdays into IFs – VERY URGENT FOR WORK

Hi,

Apologies i’m a novice with this. However, i need to add Networkdays into the following IF Formulas 

 

1.)  =IF(G3<>””,(G3-IF(E3<>””,E3,A3)),NETWORKDAYS(A3,G3,))

 

I’ve already attempted to do this one, but it is still counting weekend dates. I know i need to add the networkdays into the IF again but whereever i do it doesn’t work. 

 

2.)=IF(E3<>””,E3-A3,”N/A”)

Need to add network days into the above IF too.

 

 

I apprecaite any comments or amended formulas to try

 

Thanks

 

 

 

 

 

 

By: Craig

Leave a Reply

Your email address will not be published. Required fields are marked *