I have range A2:B7 bonus shares history of a company.I am looking for a
function in E3 to get Number of shares I hold On Sale date(E2).My data is
Col A -------------Col B ---------Col C ------Col D ----------Col E
1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date
2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 ---
25-Aug-2006
3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ?
4. 19-Jan-2006 ----- 1:1
5. 25-jan-2007 ------ 1:2
6.
7.

D2=shares buy date,D3= number of shares bought.I am looking for a function
in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI
bought+bonus shares yield).answer is 240.