PDA

View Full Version : Solved: Networkdays #name? error



neditheg
12-05-2011, 03:26 AM
Hello, I have a problem with the "networkdays" function ... and I don't know how to solve it! :|

I've attached a file with my example.


=NETWORKDAYS(K4;L4;holidays) --> this is my statement ... and It worked .... just fine ....but... now ..without a good reason for me ... I get the "#NAME?" -- message error. I'm asking why.. and how can I solve this!

Thanks!

Bob Phillips
12-05-2011, 05:54 AM
It works fine for me, so I guess you don't have the Analysis Toolpak installed (NETWORKDAYS is part of the ATP prior to Excel 2007).

neditheg
12-05-2011, 06:18 AM
thanks! solved!