Function that distributes numbers depending on the quarter and year

[managingcrap]

Guys,

I'm trying to find out a function that allows me to evenly spread the amounts given a certain start year and quarter and end year and quarter. Let's say, I have 20 dollars and the starts in 3Q/2012 and ends in 2Q/2013. Then, the money should be spread out in four quarters. If the end is in 3Q/2013, then the spread is five quarters, and the amount distribution automatically changes.

Attached is my spreadsheet.

Thanks.

[Miroslav R.]

Hi there,
If it is possible to change the data in row2 (from quarter to quarter&year), You can put following formula to F4 and drag down & right:

Please Login or Register  to view this content.

Could be that there are shorter formulas, but it works also with mine.
Distribution.xlsx

Hope it helps

[kvsrinivasamurthy]

Pl see attached file with formula.

[managingcrap]

Holy Guacamole, you are genius. Thanks.

[managingcrap]

Pl see attached file with formula.

By any chance can you tell me what the function is saying. It looks completely foreign to me but it sure does work.

Thanks