Results 1 to 4 of 4

formula for commit date minus completion date excluding weekends

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    formula for commit date minus completion date excluding weekends

    Hello, I'm trying to calculate the number of week days a project is either delayed or ahead of schedule
    Here is a example:
    Commit date is Friday 12/21/2012 and the actual completion date is Monday 12/24/2012. The net delay should be +1
    Commit date is Monday 12/24/2012 and the actual completion date is Friday 12/21/2012. The net delay should be -1

    The formula I'm using is the following:
    =NETWORKDAYS(commit date,completion date)

    But when i use this function the returned number is either +2 or -2 in stead of +1 or -1

    What am i doing wrong, can anyone help me fix this?
    I'm using Excel 2007

    Joe
    Last edited by jtmayo; 12-07-2012 at 08:21 PM.

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