Help with formula please

[blackie42]

Hi

Using the following formula highlight if the 2 dates are more than 2 days apart.

=IF(G276="", "", IF(G276=F276, "Yes", IF(G276=F276+1, "Yes", IF(G276=F276+2, "Yes", "No"))))

However I need it to ignore weekends - can't figure out how to do it. So if 30/5 & 2/6 it should
return Yes rather tan No.

Any help appreciated.

thanks

[Bob Phillips]

Try

=IF(G2="","",IF(NETWORKDAYS(F2,G2)>2,"Yes","No"))

[blackie42]

Thanks Bob,

Works like a dream.

regards