Calculate the monthly rent income
I want to calculate the rent income for each month separately. My issue is always I have to select the relevant months (rent period) and calculate the rent income. I have more than 500 rent contracts. So it is very difficult to select the period (rent period) manually. I have attached the excel for your reference & I already calculate the rent manually selecting the period. (I have highlighted the cell range which I want to fill). Any suggestions for this.
Last edited by Lahiru2024; 03-26-2024 at 11:28 AM. Reason: Solved
Welcome to the forum!
Try in C13=IF(MEDIAN(EOMONTH(C$3,-1)+1,C$4,$A13)=$A13,MIN(C$4,EOMONTH($A13,0))-MAX(C$3,$A13)+1,0)*C$7
copy down and across.
Thank you for your suggestion. It really helps me to reduce my work load. I really appreciate you. Thank you very much...
By the way, the first part of the formula "MEDIAN(EOMONTH(C$3,-1)+1,C$4,$A13)=$A13" could be replaced by "AND(EOMONTH($A13,0)>=C$3,$A13<=C$4)".
Yes. Both formulas are working properly. Thank You for your support.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks