Auto Populate Data between dates

[rygar24]

Hello,

I have a unique question. I am trying to auto populate data (resource needs) between two dates in excel. For instance, each month from January 2015 (start month) to December 2017 (end month) I need 5 resources. Jan 2015=5 resources, Feb 2015=5 resources, and so on all the way to December 2017. In Column P, I have my resource need and in columns J and K I have the start and end dates. Without having to reference the resource need cell and drag it manually from the start to end date, I would like excel to see the start and end date and auto populate the resource need throughout these months. I know this can be done, but can't seem to figure it out. Someone please help!! Thank you!

Ryan

 

[nils7]

Hi Ryan,

It is not quite clear where your output data is, so I am making some assumptions:

I assume you have the start date in J2 and the end date in K2.
I assume you have the resource need in P2
I assume you have a timeline of months in row 5
The resource need per month is in row 6.

The formula to put into A6 (and then drag across) is:

=IF(AND($J$2<=A5,A5<=$K$2),$P$2,"")

I hope this is what you were after. If not, give us some more information on your data setup.

Cheers,

Nils