# [SOLVED] Calculating days between current date and a date in future NETWORKDAYS() fun

1. ## [SOLVED] Calculating days between current date and a date in future NETWORKDAYS() fun

Hi,

I have tried using the networkdays() function as described in the help
topics.
However it doesnt' seem to help. The cell has the following formula and it
displays #NAME?
=networkdays(B9,B10,{38395;38396;38402;38403;38409;38410;38416;38417;38423;3
8424})

B9 = 2/10/2005
B10 = 3/18/2005 &
the rest of it is a range B11:B20 which contains dates for the weekends
between the values in B9 & B10

Expected: I am expecting it to display the number of days between B9 & B10
dates excluding the weekends specified.
Actual: #NAME?

If you can please correct where I am wrong OR an alternate way of getting
this is fine too.

Your help is appreciated.

Regards
-Faheem

PS:
Pasted the help content below..
AB
DateDescription
10/01/2008Start date of project
3/01/2009End date of project
11/26/2008Holiday
12/4/2008Holiday
1/21/2009Holiday
=NETWORKDAYS(A2,A3)Number of workdays between the start and end date above
(108)
=NETWORKDAYS(A2,A3,A4)Number of workdays between the start and end date
above, excluding the first holiday (107)
=NETWORKDAYS(A2,A3,A4:A6)Number of workdays between the start and end date
above, excluding every holiday above (105)

Note To convert the range of cells used for holidays in the last example
into an array constant, select reference A4:A6 in the formula and then press
F9.

2. ## Re: Calculating days between current date and a date in future NETWORKDAYS() function

You need to install the Analysis Toolpak Add-in (Tools/Add-ins, check
the appropriate checkbox).

In article <OtusZA6DFHA.2220@TK2MSFTNGP09.phx.gbl>,
"Faheem Khan" <fak_4u@hotmail.com> wrote:

> Hi,
>
> I have tried using the networkdays() function as described in the help
> topics.
> However it doesnt' seem to help. The cell has the following formula and it
> displays #NAME?
> =networkdays(B9,B10,{38395;38396;38402;38403;38409;38410;38416;38417;38423;3
> 8424})
>
> B9 = 2/10/2005
> B10 = 3/18/2005 &
> the rest of it is a range B11:B20 which contains dates for the weekends
> between the values in B9 & B10
>
> Expected: I am expecting it to display the number of days between B9 & B10
> dates excluding the weekends specified.
> Actual: #NAME?
>
> If you can please correct where I am wrong OR an alternate way of getting
> this is fine too.
>
> Your help is appreciated.
>
> Regards
> -Faheem
>
> PS:
> Pasted the help content below..
> AB
> DateDescription
> 10/01/2008Start date of project
> 3/01/2009End date of project
> 11/26/2008Holiday
> 12/4/2008Holiday
> 1/21/2009Holiday
> =NETWORKDAYS(A2,A3)Number of workdays between the start and end date above
> (108)
> =NETWORKDAYS(A2,A3,A4)Number of workdays between the start and end date
> above, excluding the first holiday (107)
> =NETWORKDAYS(A2,A3,A4:A6)Number of workdays between the start and end date
> above, excluding every holiday above (105)
>
>
> Note To convert the range of cells used for holidays in the last example
> into an array constant, select reference A4:A6 in the formula and then press
> F9.

3. ## Re: Calculating days between current date and a date in future NETWORKDAYS() function

On Thu, 10 Feb 2005 10:41:13 -0800, "Faheem Khan" <fak_4u@hotmail.com> wrote:

>I have tried using the networkdays() function as described in the help
>topics.
>However it doesnt' seem to help. The cell has the following formula and it
>displays #NAME?

You need to check Excel HELP for the function:

====================
If this function is not available, and returns the #NAME? error, install and

How?

In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.
======================

--ron

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1