# Thread: Formula - distributing data over months Thanks: 0 Likes: 0

1. ## Formula - distributing data over months

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?

Thanks,
Stecky

2. ## Re: Formula - distributing data over months

 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

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