#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default NETWORKDAYS function

I hjave installed the data analysis tool but this function (and the WORKDAY
function for that matter) do not work. By this I mean that when I type in the
function =NETWORKDAY or =WORKDAY and open the brackets it does not seem to
recognise it as a function.... any ideas?!

cheers,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default NETWORKDAYS function

Persevere because it doesn't on mine either but the formula still works.

=NETWORKDAYS(A1=TODAY())

Formatted as general

Mike

"kippers" wrote:

I hjave installed the data analysis tool but this function (and the WORKDAY
function for that matter) do not work. By this I mean that when I type in the
function =NETWORKDAY or =WORKDAY and open the brackets it does not seem to
recognise it as a function.... any ideas?!

cheers,

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default NETWORKDAYS function

and that should be

=NETWORKDAYS(A1,TODAY())

"Mike H" wrote:

Persevere because it doesn't on mine either but the formula still works.

=NETWORKDAYS(A1=TODAY())

Formatted as general

Mike

"kippers" wrote:

I hjave installed the data analysis tool but this function (and the WORKDAY
function for that matter) do not work. By this I mean that when I type in the
function =NETWORKDAY or =WORKDAY and open the brackets it does not seem to
recognise it as a function.... any ideas?!

cheers,

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
Nesting Networkdays function inside and If function Addison Excel Worksheet Functions 2 April 13th 06 08:04 PM
networkdays function help Deb Bagby Excel Worksheet Functions 3 November 1st 05 05:36 PM
Function "Networkdays" Allen7575 Excel Worksheet Functions 1 April 11th 05 09:48 PM
Networkdays function Susan Hayes Excel Worksheet Functions 2 April 5th 05 06:59 PM
Nested IF Function, Date Comparing, and NetworkDays Function carl Excel Worksheet Functions 2 December 29th 04 09:57 PM


All times are GMT +1. The time now is 11:25 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"