Thank you, this is very helpful.
Ross

"daddylonglegs" wrote:


Try this

=IF(C8="","",LOOKUP(NETWORKDAYS(C8,IF(D8,D8,TODAY( ))),{0,2,4;"","Amber","Red"}))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521681