+ Reply to Thread
Results 1 to 9 of 9

Network days error

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    Glasgow, Scotland
    MS-Off Ver
    2010
    Posts
    6

    Network days error

    I have a date field. When I enter a date I have another date field which takes the original date field and adds 10 workdays ie response due date. I have another field which counts the number of days (net workdays) until the response due date. I use networkdays and today functions. It appears ok but when the response due date equals today the counter shows a value of 1 but one day later the value of -2. I would be grateful for any assistance.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,474

    Re: Network days error

    Welcome to the forum. Love to help but ...

    I would be grateful for any assistance.
    Based on what? . No workbook, no worksheet(s), no data, no formula(e) ... not even the cell references and cell contents (dates).


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-20-2015
    Location
    Glasgow, Scotland
    MS-Off Ver
    2010
    Posts
    6

    Re: Network days error

    Apologies, this is something I am doing at work, I was trying to explain in a simple manner (obviously not done too well). I will post again with formula. It is to do with inclusive days I think. If you add -1 to the formula it is fine for positive values but negative it doesn't work.

  4. #4
    Registered User
    Join Date
    08-20-2015
    Location
    Glasgow, Scotland
    MS-Off Ver
    2010
    Posts
    6

    Re: Network days error

    Cell A3 – manually enter date
    Cell J3 - =IF(ISBLANK(A3),"",WORKDAY(A3,10))
    Cell K3 - =IF(L3>0,"",IF(O3>0,"COMPLETE",IF(ISBLANK(A3),"",(NETWORKDAYS(TODAY()+1,J3)))))
    If one day left counter shows value of 1
    In due today counter shows -1 (how do I make this value 0)
    If due yesterday counter shows -1

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,474

    Re: Network days error

    What's in L3 and O3? We're getting closer but I'm not going to build a workbook so I can populate it with my best guess at what you are trying to do. Sorry.

    Post a sample workbook with examples of what you might find in those cells and what you would hope to get out at the end.

    Regards, TMS

  6. #6
    Registered User
    Join Date
    08-20-2015
    Location
    Glasgow, Scotland
    MS-Off Ver
    2010
    Posts
    6

    Re: Network days error

    L3 is a holding response date and L3 is a date when final response is sent. L3 may never have a value.

  7. #7
    Registered User
    Join Date
    08-20-2015
    Location
    Glasgow, Scotland
    MS-Off Ver
    2010
    Posts
    6

    Re: Network days error

    Sorry, I can't seem to add a sample but field A3 is the date created, J3 is 10 workdays from that date and cell K3 is a counter that drops a day each day. But when it reaches date due ie today i would like it K3 to show 0 and on Monday to show -1.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,474

    Re: Network days error

    Maybe this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached sample workbook.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-20-2015
    Location
    Glasgow, Scotland
    MS-Off Ver
    2010
    Posts
    6

    Re: Network days error

    I may not get to check until Monday. Thank you for spending time to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Network days formula
    By Helen Pitteway in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2015, 05:49 AM
  2. network days
    By fentiger79 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2014, 04:54 PM
  3. [SOLVED] Subtracting Hold Days from Network Days Formula
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2012, 08:30 AM
  4. Network days
    By fithawk in forum Excel General
    Replies: 13
    Last Post: 11-05-2011, 06:17 PM
  5. [SOLVED] Network Days
    By dinadvani via OfficeKB.com in forum Excel General
    Replies: 3
    Last Post: 07-21-2006, 06:10 AM
  6. Network days question
    By Annette in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2006, 11:25 AM
  7. [SOLVED] Error with NETWORK DAYS function
    By Darran in forum Excel General
    Replies: 2
    Last Post: 05-08-2006, 06:35 AM

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