| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "No RETURN() or HALT() function found on macro sheet." | Excel Worksheet Functions | |||
| No RETURN() or HALT() function found on macro sheet | Excel Discussion (Misc queries) | |||
| YEAR function name not found | Excel Worksheet Functions | |||
| Reference Cell if Found in a IF function | Excel Worksheet Functions | |||
| TIR.NO.PER function, where do i found it in Office 2003??? | Excel Worksheet Functions | |||
Linear Mode
