| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't get NETWORKDAYS formula to work, it returns #NAME?
What am I doing wrong? The dates are dates & not a text.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get NETWORKDAYS formula to work, it returns #NAME?
It is a ATP function. From menu ToolsAddInscheck AnalysisToolPak
If this post helps click Yes --------------- Jacob Skaria "Sarah" wrote: What am I doing wrong? The dates are dates & not a text. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get NETWORKDAYS formula to work, it returns #NAME?
You star!! Thank you very much.
"Jacob Skaria" wrote: It is a ATP function. From menu ToolsAddInscheck AnalysisToolPak If this post helps click Yes --------------- Jacob Skaria "Sarah" wrote: What am I doing wrong? The dates are dates & not a text. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get NETWORKDAYS formula to work, it returns #NAME?
Or if you have already installed the Add-in make sure you are referring to
dates.. ColA ColB ColC ColD 7/16/2009 8/16/2009 8/1/2009 =NETWORKDAYS(A1,B1,C1:C3) 8/2/2009 8/3/2009 If this post helps click Yes --------------- Jacob Skaria "Sarah" wrote: You star!! Thank you very much. "Jacob Skaria" wrote: It is a ATP function. From menu ToolsAddInscheck AnalysisToolPak If this post helps click Yes --------------- Jacob Skaria "Sarah" wrote: What am I doing wrong? The dates are dates & not a text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Networkdays returns 1 | Excel Worksheet Functions | |||
| holidays does not work properly in networkdays funtion. | Excel Discussion (Misc queries) | |||
| How to work out annualized % returns | Excel Discussion (Misc queries) | |||
| NETWORKDAYS calculation returns inconsistent results | Excel Worksheet Functions | |||
| NETWORKDAYS Function doesn't work | Excel Worksheet Functions | |||
Linear Mode
