Wow very nice formula, not being a programmer I could have never even got
close. I do have one question, I think I miss communicated the part of if the
amount goes past the forecast I still need it to put the amount for the
months on the forecast and the overflow amount will not be shown. Is that
an easy fix?
I really appreciate your help!
Charles


"T. Valko" wrote:

Ok, if I understand you that means if the end date is greater than the last
date in row 2 no forecast is calculated.

It may be easier to show you how I did this in a sample file.

Sample file:

Charles.xls 16kb

http://cjoint.com/?fxtzLpjmPc

I only plotted through the end of 2007. Note how I use the full date. I
entered the formula in cell D3 then copied across then down.

Biff

"Charles" wrote in message
...
Yes, it is for a 3 year forecast, theoretically there could also be some
that
goes past the three years therefore that amount would not show up under
any
date in the forecast.

"T. Valko" wrote:

Will any of the date periods span into the next year?

Biff

"Charles" wrote in message
...
I have the need to create a formula that calculates the number of months
between cell B3 and C3 then divide that number by the amount in cell A1
then
find the "start date" month and put the value for each month until the
"end
date" is reached. I hope this makes since, and I appreciate any help
you
can
give me!!

1 A B C D E F
2 Amount start date end date Jan-07 Feb-07 Mar-07
3 $ 100,000 Feb-07 Sep-07

Thanks,
Charles