• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rent calculation based on each month's remaining days

alexandros6600

New Member
Dear Community,

Once again a big help request.

How can a fixed annual rent amount be calculated based on each month's remaining days (28,30 or 31)
But for the whole months of the rental period, the amount that should be charged is based on the (annual rental)/12.
For example the rental period is set from 14/06/2024 till 27/12/2024
In this period there are 17 days in June + 5 whole months + 27 days in December.

Please refer to the book attached
 

Attachments

  • Book 2024.xlsx
    10.4 KB · Views: 8
I would use a slightly different approach and do it by the total number of days

Excel 2016 (Windows) 64 bit
B
19
=B2/365​
20
=DATEDIF(A2,D2,"D")​
21
=B19*B20​
Sheet: Sheet1
 
Dear AlanSidman,

Thank you for your response. At first I had also a similar approach like yours.
It gives a slight different amount 13.424,66 vs 13.411,71.
That is a "big" difference since it has to be calculated in the way described in the book.
For June the amount is divided by 30 - the total days of June e.g 2.083,33 €/30 = 69,44 € per day of June
whilst for December is divided by 31 - the total days of Dec e.g 2.083,33 € €/31 = 67,20 € per day of December
 
Back
Top