Network days if

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble with a formula that will calcularte the network days between cells C3 and G3 unless G3 is blank then I want the networkdays between C3 and D3. Thanks for any help. This is what I ha

=IF(G3="","",NETWORKDAYS(C3,G3)),IF(C3="","",NETWORKDAYS((C3),(D3))

thanks
Mark
 
Hi
try
=IF(G3<>"",NETWORKDAYS(C3,G3),NETWORKDAYS(C3,D3))

--
Regards
Frank Kabel
Frankfurt, Germany
Mark said:
I am having trouble with a formula that will calcularte the network
Click to expand...
days between cells C3 and G3 unless G3 is blank then I want the
networkdays between C3 and D3. Thanks for any help. This is what I
had
 
Back
Top