Hi Phil,

Am Mon, 9 Feb 2015 03:53:59 -0800 (PST) schrieb Phil:

=IF(B4<"","CLOSED",(NETWORKDAYS(A4,TODAY(),B_H)-1)-$A$2)*-1

try:
=IF(ISNUMBER(B4),"CLOSED",-(NETWORKDAYS(A4,TODAY(),B_H)-$A$2-1))

D4 Returns a 1 is something has missed target and is still open, so I can add these occurences up.
=IF(C4<0,IF(B4="","1",""))

try:
=IF(AND(C4<0,LEN(B4)=0),1,"")

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional