+ Reply to Thread
Results 1 to 4 of 4

Get the start date and end date of project in a range of Project Allocation

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Post Get the start date and end date of project in a range of Project Allocation

    hello -

    I need some help in getting the start date and end date in the entire duration project allocation using a formula or function. I've attached a sample for your reference.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Get the start date and end date of project in a range of Project Allocation

    why F5 is 02-Feb even-though V3=5
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Re: Get the start date and end date of project in a range of Project Allocation

    Good point, please ignore the 5 in V3. Ideally, allocation for Base contract is until Feb 2 (friday)

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Get the start date and end date of project in a range of Project Allocation

    Try the following array entered formulas*.
    In E5: =MIN(IF((I$3:I$20=B5)*(J$3:J$20=C5)*(K$3:K$20=D5)*(M$3:V$20>0),M$2:V$2))
    In F5: =MAX(IF((I$3:I$20=B5)*(J$3:J$20=C5)*(K$3:K$20=D5)*(M$3:V$20>0),M$2:V$2))+4
    1) Select the cell in which you want to put the first formula (E5),
    2) Paste the formula into the formula bar,
    3) *Simultaneously press the Ctrl, Shift and Enter keys,
    4) Drag the fill handle down.
    Repeat these steps for the second formula.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Sum values in cells based off of project name and project end date
    By ronalgreen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2013, 01:08 AM
  2. [SOLVED] Match date to project in array and calculate days since last project of same name
    By peepingtom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-22-2013, 12:37 AM
  3. Spreading Hours based on Project Phases and Start/End Date
    By ChelseaT20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2012, 04:38 PM
  4. Replies: 0
    Last Post: 06-14-2012, 02:49 PM
  5. Compute Project Start/End Date
    By COGICPENNY973 in forum Excel General
    Replies: 0
    Last Post: 01-28-2011, 01:15 PM
  6. Replies: 1
    Last Post: 03-17-2010, 07:02 AM
  7. [SOLVED] Project Management - Start & End Date Calculations
    By Jean McC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2006, 06:10 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