calculating revenue over months

N

Nikhil

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with dates & calculations 3
To Calculate the qty b/w two dates 3
Conditional lookup 2
When building a chart Dates are been included that are not in thedate range 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
How to getting text labels to show up in scatter chart. 0
Need Formula 2
Difference between last date of month and given date 3

Top