Hi,

Am Thu, 27 Sep 2012 15:13:58 +0000 schrieb D4WNO:

Y2 = CRB Date (if it has one, else should say "No CRB Date")
02 = Resolution Date (if it has one, else should say "Open" - as it
hasn't yet been resolved)

If has has both then it should do the NETWORKDAYS calculation.

Below is what I have but Excel doesn't like it, does anyone know what
I've done wrong?

IF(Y2="","No CRB date"),(O2="","Open"),NETWORKDAYS(Y2,O2)-1)))

try:
=IF(LEN(O2)=0,"Open",IF(LEN(Y2)=0,"No CRB date",NETWORKDAYS(Y2,O2)-1))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2