PDA

View Full Version : [SOLVED] Help with formula please



blackie42
06-03-2014, 06:39 AM
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
06-03-2014, 09:14 AM
Try

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

blackie42
06-04-2014, 01:29 AM
Thanks Bob,

Works like a dream.

regards