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