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