Help

whiteknight · #6 03-09-2021, 10:26 AM

Quote:

Originally Posted by wiganken

In any case my formula was wrong. You showed monthly fees so I should have multiplied the result by 12. The new formula would be "=12*SUM(D2

5)".

Again replace the smiley with ": D" together i.e. No space.

Does this answer your question?

Thanks again
that would answer me if only all the contract start on 1/1/20
but in my case there are different starting date in many of the contracts
so like one contract "start date in 25-05-2019 and end date in 24-05-2029"
and I only need the income during the year 2020.