Prorated Rent Calculator

Last Updated: Jan 7, 2026

$

Created by
Saqib Hanif
Saqib Hanif

Saqib Hanif is the CEO and founder of Calculator Value. He builds calculators and educational content across sports, math, and science, and supports a limited set of construction-related calculators. Read full profile

Reviewed by
Muhammad Waqar
Hafiz Muhammad Waqar

Hafiz Muhammad Waqar is a finance, real-estate, and sports-related calculators reviewer at Calculator Value. He is self-taught through online learning and practical experience. He drafts and reviews finance-related calculator explanations and supporting content, helping to present key assumptions and methodology in simple terms, and does not provide financial advice. He also supports the review of sports-related calculators where applicable. Read full profile

Prorated rent calculates fair rent based on the exact days occupied in a partial month, often for mid-month moves. It requires the monthly rent amount, move date, and total days in the month.

Formula: Prorated Rent = (Monthly Rent / Days in Month) × Days Occupied

Example: Monthly rent is 1500, month has 30 days, move-in is on the 18th.

Step 1 (Daily rent): Daily Rent = 1500 / 30 = 50

Step 2 (Days occupied): 13 days (from the 18th to the 30th).

Step 3 (Prorated rent): Prorated Rent = 50 × 13 = 650

The prorated rent is 650.

  • Industry-Standard Formulas: The formulas and methods used in this calculator follow widely accepted standards in Financial.
  • Careful Verification: The calculator is tested to ensure it behaves correctly across a range of inputs.
  • Continuous Updates: The calculator is updated as needed to reflect better accuracy and usability.

No matter whether you're a property owner, real estate investor, or landlord, you want to ensure that your property remains occupied at all times. Regardless of the day of the month a tenant moves in or out, you want to ensure that you don't miss any rental income. In such situations, you expect your tenant to pay for the exact number of days they occupy the property, which is also referred to as prorated rent.

If you're a tenant, you want to pay only for the days you move in or out of the property, in simple words, the partial rent for the days you actually lived there.

Disclaimer: This calculator is for informational purposes only and is not legal or financial advice. For advice specific to your situation, consult a qualified attorney, local housing authority, or property professional.

Tenant receiving keys (Prorated Rent Calculator)

What is prorated rent?

In simple words, prorated rent is the amount the tenant pays based on how many days they stay in the rented property rather than a full month, e.g imagine renting an apartment and moving in, and it's the 10th January of the month. So instead of paying for the full month you would pay only for the 20 days, which is approx. 66.7% of the full month's rent (assuming a 30-day month).

Actually the prorated rent is a win-win, the tenant pays for the days they live there and the landlord receives the fair payment for the time the property was rented.

Why is Prorated Rent Important?

Imagine that you have rented an apartment on the 18th day of the 30-day month, so in that situation paying for the full month's rent does not make sense, right? Similarly, if you're leaving the apartment before the end of the month the landlord may ideally not charge for the days you did not stay there.

However, the prorated rent avoids misunderstandings between the tenants and the landlords, and it keeps the process fair and transparent.

When Do You Pay Prorated Rent?

  • Mid-month move in: if your lease starts on a day in the middle of the month rather than the 1st day of the month.
  • Early move out: if your lease ends before the last day of the month
  • Short stays: for any contracts or leases that do not align with a full month.

How to calculate prorated rent in Excel or Google Sheets

We have prepared a dedicated Excel and Google Sheets template to help you calculate prorated rent offline without any issues. We’ve put in careful effort to create this spreadsheet, and we hope you find it useful if you work with Excel or Google Sheets.

You can simply download the Excel file or make a copy of the Google Sheets template to estimate prorated rent easily. It features a clean and professional interface, so you can calculate your rent in just a few steps.

How to Calculate Prorated Rent

You can calculate the prorated rent in a simple and straightforward way by using our prorated rent calculator, as you just need to know those key details in order to calculate prorated rent:

Inputs:

  • Monthly rent: ______
  • Move-In or move-out : ______
  • Moving date: ______

Here are the Steps:

  • The Monthly rent amount.
  • The move in or move out options.
  • The date of the month you have moved in or out.

By filling all those details in the fields, you will get the result immediately.

You may want to know that how the prorated rent is calculated, the formula showing below is used to calculate prorated rent:

  • Prorated Rent = (Monthly Rent / Days in Month) × Days Occupied

Our calculator uses the actual days in the month and counts the move-in day as one day, but it does not count the move-out day. If needed, you can adjust the move-out day based on your landlord’s policy.

Example Calculation:

  1. Monthly Rent: $1500
  2. Tenant moves in on the 18th of a 30-day month.
  3. Daily Rent = $1500 / 30 = $50 per day
  4. Days Occupied = 13 days (from the 18th to the 30th)
    (The move-in day is usually counted, but whether the move-out day is counted depends on your lease or landlord’s policy.)
  5. Prorated Rent = $50 x 13 = $650

The calculated amount is $650, which the tenant pays for the partial month.

Keep in mind that prorated rent can be calculated using methods such as the 30-day standard, annual daily rate, or actual days in the month, depending on your lease or landlord’s policy.

Tips for Handling Prorated Rent

  • Confirm Dates: First, you have to ensure that you and your landlord agree on the date of move-in and move-out and also how the prorated rent will be calculated.
  • Check the lease: You have to check this, since some agreements specify whether the prorated rent is calculated using the fixed days or exact days.
  • Use a calculator: If your math is not strong, don't worry, the online prorated rent calculator can do that work for you

Frequently Asked Questions

What is prorated rent?

The prorated rent is the partial rent amount calculated when a renter occupies the rental properties in the middle of the month instead of the 1st day of month. The prorated rent allows renters to pay only for the exact number of days they stay or live in the property instead of paying for the full month.

How is prorated rent calculated?

The prorated rent is calculated based on the daily rental rate, which is derived from the monthly rent (e.g $500 rent monthly) divided by the number of days in a month (e.g 30-day month) and the renter pays the daily rate multiplied by the exact number of days they stay or live in the property (e.g 16 days).

Here is the Formula for Prorated Rent:

  • Prorated Rent = (Monthly Rent / Days in Month) × Days Occupied

Example of calculation:

  • Monthly rent : $500
  • Number of Days in the Month: 30
  • Move-in date: 16th of the month (14 days are Occupied)

Here is the calculation:

  1. Daily Rent = Monthly Rent / Number of Days in Month = $500 / 30 = $16.67 per day
  2. Prorated rent = $16.67 × 14 days = $233.38

The renter pays $233.38 for the partial month.

When is prorated rent applicable?

The prorated rent applies when a tenant moves in or moves out of the property after the 1st of the month, or when a tenant rents the property for less than a full month. The prorated rent ensures that the renter pays for only the days they actually live in the rental property and the landlord receives fair payment for the days the tenant occupied.

Why is prorated rent important?

The prorated rent makes the process fair and transparent for both tenants and the property owner. By adjusting the payment for the specific number of days a renter occupies the property, prorated rent ensures that neither party pays or receives more or less than what is fair for the time the property is occupied.

Can prorated rent be negotiated with the landlord?

Yes, it actually depends on the landlord's policies, circumstances, and rental situation for the prorated rent negotiation. If your lease agreement does not specifically mention prorated rent, you can open a discussion with your property owner to request for a fair adjustment.

Does prorated rent include utilities or other fees?

It actually depends on, for example If your rent includes utilities or fees, then your prorated rent may also include a a proportional share of those costs. If you pay utilities separately, they may not be included.

How do I know the total days in a month for prorated rent calculation?

You can use the calendar to know the exact number of days in a month for the prorated rent calculations, as the days in the month do vary:

  • February: 28 days (29 days in leap years)
  • April, June, September, November: 30 days
  • All Other Months: 31 days.
Month (First Half)DaysMonth (Second Half)Days
January31July31
February28 (29 in leap years)August31
March31September30
April30October31
May31November30
June30December31
What happens if I move in or out mid-month?

If you move in mid-month, then you are responsible for paying the prorated rent from your move-in date to the end of the month. Conversely, if you move-out in the middle of the month, you may pay the prorated rent from beginning of the month to your move-out date.

Can prorated rent be charged for a partial day?

Typically, in most cases, the prorated rent is calculated based on the full days not partial days. Whether you move in the morning or late in the evening the day is counted as one full day for prorated rent, but it can also depend on the property owner’s policies.