Prorated Rent Calculator: Actual Days, 365-Day and 30-Day Methods

How to calculate prorated rent: the formula

Prorated rent = daily rate x days the tenant is responsible for the unit. The only argument is how to get the daily rate, and there are three common ways to do it.

None of the three is the "correct" one in general. The lease decides which applies, and if the lease is silent, local law or local practice may. Whatever method you pick, write it into the lease so the number is not a surprise at move-in.

I'm not a landlord or property manager; I build the arithmetic. The $1,850 rent and the dates below are assumptions to replace with your own lease figures. Nothing here is legal advice.

Prorated rent calculator: all three methods side by side

Enter the monthly rent, the number of days in the month, and the days occupied. The calculator returns the actual-days figure as the headline, with the 365-day and 30-day results and the gap between them underneath.

The defaults are the move-in example below: $1,850 rent, a 31-day month, 12 days occupied, giving $716.13. Change the month length to 28 and watch the actual-days figure jump while the other two stay put. Count the days inclusively (next section) before you type them in.

Prorated rent for move-in: worked example

For a move-in, count from the move-in day to the last day of the month, including both. A tenant who moves in on October 20 has 12 days in October (20 through 31), not 11.

Inclusive count = days in month - move-in day + 1. For October 20: 31 - 20 + 1 = 12. The most common mistake is subtracting without the +1, which drops a day of rent.

With $1,850 rent in a 31-day month, the daily rate is $59.68 and 12 days cost $716.13 on the actual-days method. On a 365-day year it is $729.86, and on a 30-day month $740.00. The spread is $23.87, about the cost of a utility bill, for the same 12 days.

The 30-day method is highest here because October has 31 days: dividing by 30 makes each day dearer than it really is in that month.

How do I calculate prorated rent when I move out?

For a move-out, count from the 1st of the month to the last day the tenant is responsible for, inclusive. Out on the 10th means 10 days, assuming the lease counts the move-out day as a rent day.

Take a tenant leaving on November 10, a 30-day month, at $1,850 rent. Actual-days: $616.67. 365-day: $608.22. 30-day: $616.67. In a 30-day month the actual-days and 30-day methods agree, so the only gap ($8.45) comes from the 365-day method.

Two things to check before using this figure. First, whether the lease allows a mid-month move-out with proration at all: many fixed-term leases and notice clauses require a full month's rent, and some charge rent through the end of the notice period. Second, whether the return of keys counts as the last day or the day before. One day at $61.67 is small, but it is the most common dispute in a move-out calculation.

Is prorated rent divided by 30 or 31? February vs 31-day months

It is divided by whatever the lease says. On the actual-days method you divide by the real length of that month: 28 or 29 in February, 30 or 31 otherwise. On the 30-day method you always divide by 30, which overcharges per day in 31-day months and undercharges in February.

The table holds rent at $1,850 and the stay at 10 days, and changes only the month length.

The 365-day column never moves because it spreads 12 months of rent ($22,200) over 365 days. The 30-day column never moves either. Only the actual-days method follows the calendar, so it swings from $660.71 in February to $596.77 in a 31-day month for the same 10 days.

February move-in example

A tenant moving in on February 15, 2027 (a 28-day February) has 14 days: 28 - 15 + 1. At $1,850 rent that is $925.00 on actual days, exactly half a month, against $851.51 on the 365-day method and $863.33 on the 30-day method. The gap is $73.49, the largest of the three examples.

So when is the 30-day method higher? In 31-day months. When is it lower? In February. In 30-day months it matches the actual-days method.

Collecting rent for the first month: two common options

Landlords usually collect the partial month in one of two ways. Both cost the tenant the same in total; they differ only in timing. Your lease and local rules decide which is allowed.

1. Prorated part month plus next full month at signing. For the October 20 move-in: $716.13 for October plus $1,850 for November, so $2,566.13 up front (before any deposit). The tenant then pays $1,850 on December 1.
2. First full month at signing, prorated amount added to the second payment. The tenant pays $1,850 at signing for November, and the $716.13 for October is added to the December 1 payment ($2,566.13 that month).

Option 1 asks the tenant for more cash on day one. Option 2 spreads it out. Neither changes the total rent over the lease.

Mid-month rent due dates

A third route avoids proration altogether: set the rent due date to the move-in day (the 20th of each month, in the example). Every payment is then a full month and nothing is prorated until move-out. The trade-off is bookkeeping: a landlord with several units ends up with several due dates. Some leases and local rules restrict due dates, so check yours.

Is prorated rent good or bad? The arithmetic, not a verdict

Prorated rent is neither good nor bad; it is a way to charge only for the days a unit is occupied. Who comes out ahead depends on the method and the month, which is why the method belongs in the lease.

• Tenant moving in late in a 31-day month: the actual-days method is cheapest ($716.13 against $740.00 on the 30-day method).
• Tenant moving in mid-February: the actual-days method is the dearest ($925.00 against $851.51 on the 365-day method).
• Landlord: the 365-day method is the only one that collects exactly 12 months of rent over a full year, which makes it easy to defend.

Over many move-ins the differences tend to wash out. On a single lease, they are the $23.87 to $73.49 in the examples above.

How to prorate rent in Texas, California and other states

Proration rules come from the lease first and then from state and local law, and they differ from place to place. I have not quoted any state's rule here because I could only repeat what an official source says, and the source should be read directly.

Before you rely on a method in any state, check three things: what your lease says about partial months and the move-out day; your state's landlord-tenant statute or the attorney general's or housing agency's tenant guide; and any city ordinance. If they conflict, the law generally wins over the lease, so ask a local attorney or tenant/landlord association if the amount matters.

The arithmetic itself does not change by state: pick the method, count the days inclusively, multiply.

Prorated rent formulas in Excel and Google Sheets

These formulas compute days and prorated rent straight from a date, so you never miscount a month. Layout: B2 = monthly rent, B3 = move-in date, B4 = move-out date (last day the tenant is responsible for), B5 = days occupied. Wrap any result in ROUND(...,2) to get cents.

For the October 20 move-in, EOMONTH(B3,0) returns October 31, DAY of that is 31, and 31 - 20 + 1 = 12 days. In February 2027 the same formula returns 28 automatically, and 29 in February 2028. Google Sheets uses the same syntax. If both move-in and move-out fall in one month, use =B4-B3+1 for the days.

After the move-in: checking a rental's numbers

A prorated rent calculator answers one question: what the partial month costs. If you are a landlord or buyer, the bigger question is whether the property earns enough every full month after tax, insurance, vacancy, repairs and the mortgage.

To be clear, the real estate investment spreadsheet does not prorate rent. It is a deal analyzer: you enter price, loan, rent, vacancy and expenses, and it returns the mortgage payment, monthly and annual cash flow, cash-on-cash return, cap rate and the 1% rule check, colour-coded green, amber or red against targets you set, in Excel or Google Sheets. It is $14.99 one-time, or part of the $49 bundle of 7 templates.

What to put in a prorated rent sheet: monthly rent, move-in date, move-out date, and the method named in the lease as inputs; days in that month, days occupied (inclusive), daily rate and prorated rent as outputs, with the other two methods beside it for comparison.

For the full-month numbers, the rental property analysis spreadsheet guide walks through a deal line by line, the rental yield calculator guide covers gross and net yield, and the cash-on-cash return guide adds financing. The rental property analysis spreadsheet puts those results in one file.

Step-by-step: Prorated Rent Calculator: Actual Days, 365-Day and 30-Day Methods

1. Check the lease for the method. Find whether partial months use actual days in the month, a 365-day year or a 30-day month. If it is silent, check local rules.
2. Count the days inclusively. Move-in: days in month - move-in day + 1. Move-out: the date of the last day the tenant is responsible for. October 20 gives 12 days.
3. Work out the daily rate. Rent / days in that month, rent x 12 / 365, or rent / 30. At $1,850 in October: $59.68, $60.82 or $61.67.
4. Multiply and round to cents. Daily rate x days. 12 days on actual days is $716.13. Round once, at the end, not the daily rate first.
5. Decide how to collect it. Prorated part month plus the next full month at signing, or a full month at signing with the balance added to the next payment, as the lease allows.

Related guides