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!

    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??
    Attached Files Attached Files

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

    Autofill as required.

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    York, England
    Excel Version
    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