# Thread: Formula Help? Date Range help...

1. ## 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  Reply With Quote

2. Beginning in cell L9, use:

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

3. This is a bit like Deep Thougt fom the 1970s!   Reply With Quote

#### Posting Permissions

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