Network Days

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

Hi

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

--
Regards

Roger Govier


"dinadvani via OfficeKB.com" <u22798@uwe> wrote in message
news:6391fdcabb5c7@uwe...
> 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
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200607/1

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.




--
Regards Ron de Bruin
http://www.rondebruin.nl



"dinadvani via OfficeKB.com" <u22798@uwe> wrote in message news:6391fdcabb5c7@uwe...
> 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
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200607/1

Thanks a lot for your help



Roger Govier wrote:
>Hi
>
>Networkdays requires the Analysis Toolpak to be loaded
>Tools>Addins> check Analysis Toolpak
>
>> Hi,
>>
>[quoted text clipped - 28 lines]
>> Thanks,
>> Dinesh

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1