Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DaZ..ign
 
Posts: n/a
Default How do I install the networkdays function!

How do I install the networkdays function! Help tells me how to use it but,
it doesn't exist in my system.

Formula as follows: =NETWORKDAYS(A2,A3,A4:A6)

Followed the instructions purrfectly, but alas the only answer I get is #NAME?

Spent over an hour on the formula... I finally did it in 10 mins with my
daughters calculator.

Help for next time!!
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If you look in help for NETWORKDAYS you can see you need ATP and there you
can see instructions to install
it as well. 1 minute in help would have told you that

keep the office/excel cd handy, select ATP from toolsadd-ins and follow the
instructions

--

Regards,

Peo Sjoblom


"DaZ..ign" wrote in message
...
How do I install the networkdays function! Help tells me how to use it

but,
it doesn't exist in my system.

Formula as follows: =NETWORKDAYS(A2,A3,A4:A6)

Followed the instructions purrfectly, but alas the only answer I get is

#NAME?

Spent over an hour on the formula... I finally did it in 10 mins with my
daughters calculator.

Help for next time!!



  #3   Report Post  
DaZ..ign
 
Posts: n/a
Default

Peo,

Well Done!

Dazz

"Peo Sjoblom" wrote:

If you look in help for NETWORKDAYS you can see you need ATP and there you
can see instructions to install
it as well. 1 minute in help would have told you that

keep the office/excel cd handy, select ATP from toolsadd-ins and follow the
instructions

--

Regards,

Peo Sjoblom


"DaZ..ign" wrote in message
...
How do I install the networkdays function! Help tells me how to use it

but,
it doesn't exist in my system.

Formula as follows: =NETWORKDAYS(A2,A3,A4:A6)

Followed the instructions purrfectly, but alas the only answer I get is

#NAME?

Spent over an hour on the formula... I finally did it in 10 mins with my
daughters calculator.

Help for next time!!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Install a Reset or Clear Function CC Excel Worksheet Functions 4 February 10th 05 10:06 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM
UUsing the NetworkDays Function with IF Statements carl Excel Worksheet Functions 1 December 30th 04 09:12 PM
Nested IF Function, Date Comparing, and NetworkDays Function carl Excel Worksheet Functions 2 December 29th 04 09:57 PM
MS Excel Function - Networkdays Nilesh Inamdar Excel Worksheet Functions 3 November 26th 04 07:10 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"