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$45 055)-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
ToolsAddins 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$45 055)-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 ?
ToolsAddins

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$45 055)-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
ToolsAddins 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