IF Statement Not Quite Working

Hello,

I'm a bit stuck with a formula on the attached spreadsheet, I'm wondering if anyone could kindly assist. The one in G3 is the one which I'm struggling with.

What I'm trying to do is say that cell G2 changes what it says depending on how far past the date in cell E2 goes. After 4 working days it needs to change to "Warning" and after 7 working days it needs to change to "Urgent". However if any date if put cell F2 I need the text to say "Done". If the date is not past 4 working days then it needs to display "Ok".

=IF(ISBLANK(E3)," ",IF(NOT(ISBLANK(F3)),"Done",IF(NETWORKDAYS(E3,TODAY(),)>7,"Urgent",IF(NETWORKDAYS(E3,TODAY(),)>4,"Warning","Ok"))))

This forumla displays the #NAME? error.

Is anyone able to help?

James

I'm confused, because your profile says XL 2003, yet you have posted an .xlsx file, but I think that might be your problem. The formula works for me (does not give the #NAME error), but if you are using XL2003 then NETWORKDAYS is not recognised until you install the Analysis Tool Pack, which is why you are getting that error.

Hope this helps.

Pete

Hi Fotis,

This is strange... have a look at my attached screenshot. Maybe my settings are wrong...?

James

yes, thank you Pete. I'm on the phone to my IT Support right now trying to see whether the Analysis Tool Pack is installed. This error might be due to half the company being on MS Office 2010 and the other half not. We're half way through the migration process. I'll let you both know if it gets sorted.

Many thanks,

James

Yep, it's my computer! Thanks for the help everyone!