Formula - distributing data over months

[Stecky]

I am trying to create a formula that distributes the data in Y1-Y20 (these are years) by month over the Rebate Start and End Date Range.

The challenge is the data changes year to year.

Can anyone help?

https://docs.google.com/spreadsheets/d/1WNP71eWU2hUl4s8PllPEWPehWiimkkiiwVZUNWpkVyo/edit?usp=sharing


Thanks,
Stecky

 

[Stecky]

Start Date	End Date	Mths Delay	Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	1/18	2/18	3/18	4/18	5/18	6/18	7/18	8/18	9/18	10/18	11/18	12/18	1/19	2/19	3/19	4/19	5/19	6/19	7/19	8/19	9/19	10/19	11/19	12/19
01/01/2018	12/31/2027	0	1	2	2	2	3	3	3	3	3	3	1	1	1	1	1	1	1	1	1	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2
06/01/2018	05/31/2029	12		2	2	3	3	3	3	3	3	3						2	2	2	2	2	2	2	2	2	2	2	2	3	3	3	3	3	3	3

<tbody>
</tbody>

I see that a lot of people have looked but I may have not done a good job explaining what I am trying to do.

If the only data I have is (Start Date / End Date / Y1-Y10). The Y are years (12 months of data).

I am trying to put the values in Y1 through Y10 on a timeline by month. I have 1000s of rows of these.

My biggest challenge is the data changing by year as I already have a formula that works if the data does not change through the years (seen below).

IF(AND(month>=Start Date, month<=End Date, value, 0) Value being that the number in Y1-Y10 does not change. Month being the date on the timeline.

Hope this helps. Thank you

Stecky