C
conorfinnegan
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
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