Why am I getting #NAME?
 

=NETWORKDAYS(N9,M9,$S$10:$S$17)

This is my formula, I'm trying to get the number of days between 2 dates,
not including weekends or hilidays. N9 and M9 are the dates, and $S$10:$S$17
is my list of holiday dates I do not want included. I can't figure out why
the formulat isn't working for me. I have dates in each cell.

Thanks in advance.

pugsly8422 wrote:
=NETWORKDAYS(N9,M9,$S$10:$S$17)

This is my formula, I'm trying to get the number of days between 2 dates,
not including weekends or hilidays. N9 and M9 are the dates, and $S$10:$S$17
is my list of holiday dates I do not want included. I can't figure out why
the formulat isn't working for me. I have dates in each cell.

Thanks in advance.

Because you don't have the Analysis ToolPak installed and referenced.

Alan Beban

Have you installed the Analysis Toolpak?

--
HTH

Bob Phillips

"pugsly8422" wrote in message
...
=NETWORKDAYS(N9,M9,$S$10:$S$17)

This is my formula, I'm trying to get the number of days between 2 dates,
not including weekends or hilidays. N9 and M9 are the dates, and
$S$10:$S$17
is my list of holiday dates I do not want included. I can't figure out
why
the formulat isn't working for me. I have dates in each cell.

Thanks in advance.

From XL Help ("NETWORKDAYS" topic):

If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.



In article ,
"pugsly8422" wrote:

=NETWORKDAYS(N9,M9,$S$10:$S$17)

This is my formula, I'm trying to get the number of days between 2 dates,
not including weekends or hilidays. N9 and M9 are the dates, and $S$10:$S$17
is my list of holiday dates I do not want included. I can't figure out why
the formulat isn't working for me. I have dates in each cell.

Does anyone know where I can get teh Analysis ToolPak?

"JE McGimpsey" wrote:

From XL Help ("NETWORKDAYS" topic):

If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.



In article ,
"pugsly8422" wrote:

=NETWORKDAYS(N9,M9,$S$10:$S$17)

This is my formula, I'm trying to get the number of days between 2 dates,
not including weekends or hilidays. N9 and M9 are the dates, and $S$10:$S$17
is my list of holiday dates I do not want included. I can't figure out why
the formulat isn't working for me. I have dates in each cell.

It comes with your installation disks.

In article ,
"pugsly8422" wrote:

Does anyone know where I can get teh Analysis ToolPak?

The Analysis Tool Pak is typically installed with Excel. Go to
the Tools menu, choose Add-Ins, and select it from there. If it
does not appear in the list, you'll have to run your Office Setup
program again to install it.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"pugsly8422" wrote in
message
...
Does anyone know where I can get teh Analysis ToolPak?

"JE McGimpsey" wrote:

From XL Help ("NETWORKDAYS" topic):

If this function is not available, and returns the #NAME?
error,
install and load the Analysis ToolPak add-in.



In article
,
"pugsly8422" wrote:

=NETWORKDAYS(N9,M9,$S$10:$S$17)

This is my formula, I'm trying to get the number of days
between 2 dates,
not including weekends or hilidays. N9 and M9 are the
dates, and $S$10:$S$17
is my list of holiday dates I do not want included. I can't
figure out why
the formulat isn't working for me. I have dates in each
cell.