LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula to spread data over a period of time PMuskie Excel Discussion (Misc queries) 2 October 23rd 09 03:44 PM
how do you calculate monthly revenue in Excel 2007 PattyJean50 Excel Discussion (Misc queries) 1 October 31st 07 07:47 AM
need help calculating revenue over period of time [email protected] Excel Discussion (Misc queries) 0 February 22nd 07 08:16 PM
How do i calculate the total revenue in Excel? wondering Excel Worksheet Functions 1 April 13th 06 07:35 PM
Is there away to save a spread sheet at the same time each day Brad Excel Discussion (Misc queries) 2 July 1st 05 01:23 PM


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"