A B C D E F G
1 Start Date End Date No. of Day Invetsment Net Profit Perday Profit
2 1 Apr 2012 10 Apr 2012 10 100000 1580 158
3 6 Apr 2012 12 Apr 2012 7 175000 1400 200
4 9 Apr 2012 16 Apr 2012 8 50000 900 112.5
The above is the data I have entered in a excel file (actual data is very huge). I want to know that on a given date what is my investment and on that date what is my profit
For Example: on 1 apr 2012 total invested amount is 100000 and profit is 158
on 7 apr 2012 total invested amount is E2+E3=275000 and profit is G2+G3 =358
on 9 apr 2012 total invested amount is E2+E3+E4=325000 and profit is G2+G3+G4
on 16 apr 2012 total invested amount is E4=50000 and profit is G4
Date Investment Day Profit
1 Apr
2 Apr
3 Apr
4 Apr
Goes on
Excel file attached...
Help.xlsHelp.xls
Bookmarks