Microsoft Excel 2002 = networkdays function

[PJname]

Problem: Recent issue -
Function:
=NETWORKDAYS(A1,A2,A3:A53)

This function was working correctly in my worksheet until recently. Now it is showing: #NAME? error in the field where the data should display. I have the [blue] Tools - Add-ins - Analysis Toolpak [/blue] box checked.

field settings:

a1 = =TODAY()
a2 = 9/21/2008
a3:a53 = dates of holidays and Fridays off

cell format = date (mm/dd/yy)

What has changed? I have not made any corrections to this field in quit a while.

 

[Rofeu]

problem's got to be in the toolpak, if it was in the data it would return #VALUE.

Try reinstalling the Analysis Toolpak.

Cheers,

Roel

 

[PJname]

Hello Rofeu,

where would I find the installation for Analysis Tookpak?

 

[Rofeu]

well, I suggest giving the AddIn install a try first, i.e. uncheck it, maybe close your excel or something, and then recheck it ('installing' and addin is merely checking the box in front of it)

If that doesn't work, you can download it from the web:

http://www.microsoft.com/downloads/...94-9e3f-487f-b7b0-e310fe2d5362&displaylang=nl

Cheers,

Roel

 

[PJname]

I tried to find the "English" version to the link that you provided above, but I have been unsuccessful.

Can you send me the link to the English version?

 

[PJname]

Dis-regard previous message. I found the English version

 

[Rofeu]

man, my mind is warped! I was reading that as if it was English, never occurred to me that it was not.

Anyway, hope it solves your problem, otherwise I'm out of ideas on this one.

Cheers,

Roel

 

[PJname]

Unsuccessful.........

I tried the download and when I open the Excel document it displays the #NAME? error again.

Does it make a difference if I am using the =today() as one of the expressions?

 

[SkipVought]

Check ALL your dates in column A.

An INVALID date will cause #NAME error.

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

A QUICK way would be to format column A as GENERAL.

All dates will be NUMBERS.

Problems will still show a "date" -- NOT!!!

Skip,
[sub]
[red][/red]
[/sub]

 

[PJname]

When I update the field using the function =networkdays... data and go in and check the links, it shows the following:


Edit Links:

Source = ATPVBAEN.XLA
Type = Worksheet
Update = A
Status = UNKNOWN

update = Automatic

When I close the document and reopen, whether I perform the update or not it will show the following in the field that I am getting the error on:

='C:\program files\microsoft office\Office10\LIBRARY\Analysis\ATPVBAEN.XLA'!NETWORKDAYS(A1,A2)

Is this the correct directory where this file should be?
Any other suggestions?

 

[PJname]

Well, I think I have solved the problem. When all else fails, SHUTDOWN your Machine and try again.

I did this and looks like it solved the problem I was having with Excel function=networkdays

Who would have thought. I appreciate all the suggestions from each of you.