Formula - distributing data over months
Results 1 to 2 of 2

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

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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?

    https://docs.google.com/spreadsheets...it?usp=sharing


    Thanks,
    Stecky

  2. #2
    New Member
    Join Date
    Jun 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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