ExcelBanter - I can't get NETWORKDAYS formula to work, it returns #NAME?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I can't get NETWORKDAYS formula to work, it returns #NAME? (https://www.excelbanter.com/excel-discussion-misc-queries/237058-i-cant-get-networkdays-formula-work-returns-name.html)

Sarah

I can't get NETWORKDAYS formula to work, it returns #NAME?

What am I doing wrong? The dates are dates & not a text.

Jacob Skaria

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.

Sarah

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.

Jacob Skaria

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.

All times are GMT +1. The time now is 02:18 AM.