On Jun 18, 6:50 am, Nikhil wrote:
I receive payments from different people every month... every month, there
are additions to the list as also people who drop out from the system.... I
want to calculate monthwise what my income is...e.g

Start Date---Payment----Termination Date Apr'08 May'08
Jun'08
12-Apr-08 5000 =(5000/30)*19
5000 5000
1-Apr-08 10000 15-May-08 10000
5000 -----
5-Apr-08 5000 25-Apr-08 =(5000/30)*21 ----
----
1-Jun-08 4000 ------
---- 4000

can some one help....the forumla becomes quite complex....and am not getting
the hang, where i am going wrong

Nikhil

I don't understand quite everything. Is your monthly income already in
the "Apr'08", "May'08", etc columns? A SUM at the bottom of the column
would be the easiest way to get the monthly total.

Or are you trying to find a better formula for the "=(5000/30)*19" in
those columns?