Results 1 to 8 of 8

Formula for identifying start date and finish date and associated number of days

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2011
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    31

    Formula for identifying start date and finish date and associated number of days

    I have a number of activities within a project with each activity having a start date and a finish date.

    What I would like is a function that looks at the 1st activity start date and the last activity finish date and convert this into the total amount of workdays taken to complete the project.

    Attached is a spreadsheet with generic data. Column A references the project with the cells I am looking to use highlighted in yellow columns B and C.

    Also I only need the dates, not the time so would like to know how to remove the time as well.
    Thanks in advance
    FBS
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 06-12-2018, 11:42 AM
  2. Count number of days from a start date to today BUT end at a certain date
    By delene_tabone in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2018, 12:56 AM
  3. Replies: 3
    Last Post: 02-10-2016, 07:26 PM
  4. Does a task start or finish date fall within 3 month range of a specific date
    By jamesmcgallan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2015, 07:46 AM
  5. Calculate start date from finish date minus 14 working hours
    By PietBom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2014, 07:23 PM
  6. [SOLVED] Find date using start date and number of network days
    By v!ctor in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 05:27 PM
  7. Replies: 8
    Last Post: 03-29-2010, 09:20 PM

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