Formula Help? Date Range help...

cantona_lives

New member
Joined
Nov 27, 2013
Messages
1
Reaction score
0
Points
0
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
 

Attachments

  • Engineer Allocation.xlsx
    21 KB · Views: 11

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
Beginning in cell L9, use:

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

Autofill as required.
 
Top