+ Reply to Thread
Results 1 to 2 of 2

Networkdays

  1. #1
    Registered User
    Join Date
    08-13-2004
    Posts
    66

    Networkdays

    ------------A------------B---------------C
    1-----03/03/05---05/05/05----=IF($A1*$B1=0,"",OR(NETWORKDAYS($A1,$B1))) = GIVES ANSWER - TRUE
    -
    2-----03/03/05---05/05/05----=NETWORKDAYS($A2,$B2) = GIVES ANSWER -3


    I have a spreadsheet in which I would like to calculate Networkdays between two dates, it works in row 2, but if I alter the formula in row one so a figure only shows in C1 if there are dates in A1 and B1 I get a "TRUE" value instead of 3. Is it possible for the correct Networkday value of 3 to show in row C1? Hope it makes sense.

  2. #2
    Registered User
    Join Date
    08-13-2004
    Posts
    66
    My mistake, i found out my error.


    the formula works with the OR value taken out


    =IF($A1*$B1=0,"",NETWORKDAYS($A1,$B1))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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