Prorated Rent Calculator: Partial Month Rent
How much is rent when I move in mid-month? Enter the monthly rent, how many days you occupy the home and how days are counted. You get the rent for the partial month and the daily rate.
Updated
Report a problem
Formula
- Daily rate:
monthly rent ÷ days in the month(actual days), ormonthly rent ÷ 30(30-day basis). - Prorated rent:
daily rate × days occupied. - On the 30-day basis the days charged never exceed 30, so a full 31-day stay costs one month's rent.
The result is rounded to cents; the daily rate shown is rounded to cents too but the calculation uses the unrounded rate.
Worked example
Rent of 1,500, moving in with 10 days left in a 31-day month:
- Actual days:
1,500 ÷ 31 × 10 =483.87 (daily rate 48.39, 32.3% of the month). - 30-day basis:
1,500 ÷ 30 × 10 =500.00.
When to use it
Use this page when a lease starts or ends part-way through a month and the agreement says rent is prorated. For landlords planning future income, the rent increase calculator shows how rent grows each year, and the rental property cash flow calculator turns rent into profit.
Second example
Rent of 1,800 for the last 10 days of a 28-day month, on actual days: 1,800 ÷ 28 × 10 = 642.86 (daily rate 64.29, 35.7% of the month). On a 30-day basis the same stay costs 600.00.
Common mistakes
- Using 30 days when the lease says actual days, or the reverse.
- Counting the move-in day but not the move-out day when the lease counts both.
- Rounding the daily rate before multiplying.
- Forgetting that deposits and utilities are not part of prorated rent.
Frequently asked questions
How do I calculate prorated rent?
Divide the monthly rent by the days in the month and multiply by the days you stay. For 1,500 over a 31-day month and 10 days: 1,500 ÷ 31 × 10 = 483.87.
Should I use actual days or a 30-day month?
Use whatever your lease says. Actual days make the daily rate change by month. A 30-day month gives a steady rate: 1,500 ÷ 30 × 10 = 500.00 for 10 days.
What if I stay all 31 days on a 30-day basis?
The charge is capped at one full month's rent, so 31 days on a 30-day basis costs the same as 30 days.
Do I count both the move-in day and the move-out day?
That depends on the lease. If you move in on the 22nd of a 31-day month and the rent covers the move-in day, you occupy 10 days (22nd to 31st). Count the days the way the lease does.
How much is prorated rent for moving in on the 15th?
In a 30-day month with rent of 1,500, moving in on the 15th means 16 days if the 15th and the 30th both count, so the rent is 1,500 ÷ 30 × 16 = 800.00.
What is the prorated rent formula in Excel?
Use =rent/DAY(EOMONTH(date,0))*days for actual days, or =rent/30*days for a 30-day basis. For rent of 1,800 in a 28-day February and 10 days, =1800/28*10 is 642.86.
How do I prorate rent when I move out mid-month?
Count the days up to and including the move-out day, then use the same daily rate. If you leave on the 10th of a 28-day month with rent of 1,800, you owe 10 days, which is 642.86. Your lease decides how the last day is counted.