Networkdays, works at home, but not at work

Hey All seem to have a problem in setting the above Formula,
I have set the cells to Date and have checked the Analysis ToolPak is in Add ins
Dont know what else to try?

I am assuming that it just wont work on this computer in work where as when I tried at home it worked

I have uploaded an example

What if you change the date format in A2 and B2 to month/day/year... mm/dd/yy

Dang Jeff - you're fast

Ok Is it me or am I loosing it altogether

I looked at your Book1 - you're loosing it - no question...

So In Formula I Enter Forumla =ISNUMBER(A2) when A2 has the Start Date and B2 has the End Date which Results in Cell C2 stating TRUE thats all??

Ya know - changing the date formats as described in two previous posts fixed this problem entirely.

EUREKA you got it
Sorry when you where saying to change the format date I was actually selecting a Date Format with Numbers ie. *22-11-12.
So No onto my next 2 Questions
Is there a way of not displaying True?
Also In my original document that will use this formula in I will have 2 Columns filled with dates open and dates closed.
So How can I add this formula to always work in all of CellA and rows and B and Rows. I can upload an Example

hAHA WELL FAIR PLAY TO YA YOU HELPED A LOT

Originally Posted by jeffreybrown

That would help because I just got lost...