calculating revenue over months

Nikhil

Guest

Posts: n/a

19th Jun 2008

I have a sheet which looks like this

Vendor Start Date Revenue End Date
A 1-Mar-08 4000
B 15-Apr-08 10000
C 1-May-08 5000 1-Jun-08
D 1-May-08 5000 25-May-08

In the next columns what i would like to have is.......

Apr-08 May-08 June-08 Jul-08 (and so on)
4000 4000 4000 (since we are in Jun, Jul
would be blank)
(10000/30)*16 10000 10000
0 5000 0
0 (5000/31)*(25-1)

Can anyone help?

« Progress bar in spreadsheet? | Tax Calculation »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Measuring growth-how much did revenue increase using 12 months of	=?Utf-8?B?QnVjaw==?=	Microsoft Excel Misc	7	11th Aug 2007 02:00 AM
Help with a calculating revenue	joseph.mccastlain@gmail.com	Microsoft Excel Misc	0	20th Mar 2007 01:13 AM
Calculating revenue over fiscal quarters	joseph.mccastlain@gmail.com	Microsoft Excel Programming	3	23rd Feb 2007 01:44 AM
Calculating revenue based on accounting months	Gazzr	Microsoft Excel Misc	7	13th Feb 2006 05:35 AM
Accural Revenue - How to divide revenue into Months	Shane Clarke	Microsoft Excel Worksheet Functions	8	30th Sep 2004 09:22 PM