Results 1 to 3 of 3

Thread: Formula Help? Date Range help...

  1. #1

    Unhappy Formula Help? Date Range help...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    Hopefully someone can help me with a formula.

    Basically I am looking to calculate how many of a certain type of resource I require on any given week.

    A9 contains the role.
    B9 the amount of effort
    C9 –to- F9 the skill required
    H9 is their effectiveness
    G9 then calculates the actual resource number – i.e 2 resources at 50% effectiveness would equate to 1 resource.
    I9 is the start date for the resource(s) to start
    J9 is the calculated finish date
    And K9 is the elapsed time

    Using row 9 as an example I would like the cells under the dates from L9 onwards to be populated with the number of Actual resources required.
    I could populate with ‘true or false based on an ‘AND’ formula. But is there a formula where I can populate between the two dates, with the number present in the Actual resource column?

    I attach the spreadsheet for reference.


    Any help and advice much appreciated. Hope this makes sense??
    -CL
    Attached Files Attached Files

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Beginning in cell L9, use:

    Code:
    =IF(AND(L$3>=$I9,L$3<=$J9),$G9,"")
    Autofill as required.

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    773
    Articles
    0
    Excel Version
    2010
    This is a bit like Deep Thougt fom the 1970s!

    Last edited by Hercules1946; 2013-11-29 at 12:55 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •