Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
It comes with your installation disks.
In article , "pugsly8422" wrote: Does anyone know where I can get teh Analysis ToolPak? |
#7
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|