ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Not Found Function (https://www.excelbanter.com/excel-discussion-misc-queries/190021-not-found-function.html)

Byron720

Not Found Function
 
I'm trying to use the function NETWORKDAYS in my Excel sheet (Excel 2003) and
it's not in the functions list. I keep getting a #NAME? message.

JE McGimpsey

Not Found Function
 
As explained in Help, for XL versions prior to XL07/08, it's part of the
Analysis Toolpak Add-in (Tools/Add-ins...)


In article ,
Byron720 wrote:

I'm trying to use the function NETWORKDAYS in my Excel sheet (Excel 2003) and
it's not in the functions list. I keep getting a #NAME? message.


Dave O

Not Found Function
 
By any chance do you need to re-install the Analysis Toolpak? Or are
you at a machine you don't ordinarily use? From the menu click Tools
Add-ins and check the box for Analysis Toolpak, then click OK. It may

take a moment to install.

Dave O
Eschew obfuscation

Marcelo

Not Found Function
 
networkdays needs the analysis toolPak.

go to menu tools - Add-ins and check the Analysis ToolPak add-in

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Byron720" escreveu:

I'm trying to use the function NETWORKDAYS in my Excel sheet (Excel 2003) and
it's not in the functions list. I keep getting a #NAME? message.


Byron720

Not Found Function
 
I checked the Add ins before. They're all checked but still it doesn't
recognize the function

"Marcelo" wrote:

networkdays needs the analysis toolPak.

go to menu tools - Add-ins and check the Analysis ToolPak add-in

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Byron720" escreveu:

I'm trying to use the function NETWORKDAYS in my Excel sheet (Excel 2003) and
it's not in the functions list. I keep getting a #NAME? message.



All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com