Quote:
Originally Posted by wiganken
Using your example: -
1/1/20 to 31/12/20 = 12 whole months
I assume your monthly income is 500+800+600+450
Ignore " " marks in the following: -
1. In another cell write "Income 1/1/20 to 31/12/20 =" and right-hand justify it.
2. In the cell to the right of that enter "=SUM(D2  5)" and press Enter.
I cannot stop the forum converting what I am typing into a smiley so imagine the smiley replaced by ": D" together but with no space.
Hope I have interpreted your question correctly. |
thanks for replying
maybe I wasn't clear .What I mean that The(500+800+600+450) is My income in the beginning of the contract period not between 1/1/20 to 31/12/20
I want to calculate my income during the year 2020 with an annual increase of 10% from the beginning of the contract