Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula to spread data over a period of time | Excel Discussion (Misc queries) | |||
how do you calculate monthly revenue in Excel 2007 | Excel Discussion (Misc queries) | |||
need help calculating revenue over period of time | Excel Discussion (Misc queries) | |||
How do i calculate the total revenue in Excel? | Excel Worksheet Functions | |||
Is there away to save a spread sheet at the same time each day | Excel Discussion (Misc queries) |