Spread Revenue Over Time - Excel Help
 

Thanks in advance to anyone that can help me out.

I have a data set in columns A through E (Name, Start Date, End Date,
Revenue, Revenue per Day). I have about 10,000 rows of data that I
would like to have a formula spread the revenue in the appropriate
month that it should fall into (assuming even distribution). So, for
example...

Pizza 1/12/2008 3/31/2008 $20,000 $250

The result I would like is for the revenue to be spread over time in
columns F through ....

January 2008 February 2008 March 2008
$5,000 $7,250 $7,750

Is there an easy formula to accomplish this?

Please let me know.

Thanks.

Conor