When a tenant moves in mid-month, rent is prorated for the days occupied. Monthly rent ÷ days in month × days occupied gives the partial rent — fair to both sides.
The example
$1,500 rent, June (30 days), 11 days.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 1500 / 30 | $50/day |
| 3 | × 11 days | → $550 |
The formula
The formula:
How it works
How it works:
- Daily rent = monthly rent ÷ days in that month (use
DAY(EOMONTH(date,0))). - Multiply by days occupied — from move-in date through month end.
- For move-out, count days from the 1st through the move-out date.
- Some leases use a fixed 30-day divisor — check the lease before choosing.
The divisor is a lease term, not a given. “Actual days in month” (28–31) and “fixed 30” (the banker’s month) give different daily rents — $1,500 prorates to $50.00/day in June but $48.39/day in a 31-day month under actual-days. Read the lease, pick the matching divisor, and apply it consistently so move-in and move-out use the same rule.
Try it: interactive demo
Monthly rent, days in month, days occupied.
Variations
Days in the month
From any date:
Days occupied (move-in)
Through month end:
Fixed 30-day proration
Banker’s month:
Pitfalls & errors
Which divisor. Actual days vs fixed 30 — follow the lease.
Inclusive days. Move-in day usually counts — add 1 in the day count.
Zero days. A bad date range gives #DIV/0! or negatives.
Practice workbook
Frequently asked questions
How do I prorate rent in Excel?
How do I get the days in the month?
Should I use actual days or a fixed 30?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class