Network Days

[dinadvani via OfficeKB.com]

Hi,

I need your help. I am facing a very different issue.

Last month I prepared a report where I had to calculate the no. of days
between 2 dates.

For Instance :

Date when call made Date when call tracker updated
8/13/06 8/17/06

Since I wanted only working days to be calculated I used Network days for
calculation purpose
=NETWORKDAYS(F10,I10,Registration!$AE$45044:$AE$45055)-1
Wherein the list range is for holidays.

I have placed this file on a shared location and earlier when anybody
accessed this file he used to get "NAME?" in the network days formula cell.
This used to get rectified when I use to open the file, but today when I
updated a few details I am getting "NAME?" in the formula cell.


PLEASE HELP.... as this is a very important report which I have prepared.

Thanks,
Dinesh

 

[Roger Govier]

Hi

Networkdays requires the Analysis Toolpak to be loaded
Tools>Addins> check Analysis Toolpak

 

[Ron de Bruin]

Hi dinadvani

NETWORKDAYS is a ATP function

Do you have the add-in installed ?
Tools>Addins

From Help:
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

 

[dinadvani via OfficeKB.com]

Thanks a lot for your help

Hi

Networkdays requires the Analysis Toolpak to be loaded
Tools>Addins> check Analysis Toolpak

Hi,

[quoted text clipped - 28 lines]

Thanks,
Dinesh