When people join a holiday rental for different numbers of nights, splitting the cost by nights stayed is fairer than an equal split. The same works for a housemate who moved in or out mid-month.
The formula
Cost for a person = Total cost × (their nights ÷ total nights of everyone)
Worked example
A holiday apartment costs 900.00 EUR for a week. Anna and Ben stay 7 nights, Chris stays 4 and Dana 3, 21 person-nights in total.
| Person | Nights | Share |
|---|---|---|
| Anna | 7 | 300.00 EUR |
| Ben | 7 | 300.00 EUR |
| Chris | 4 | 171.43 EUR |
| Dana | 3 | 128.57 EUR |
| Total | 21 | 900.00 EUR |
Fixed costs
Some costs don’t depend on how long each person stayed, such as a cleaning fee. You can share those equally with the equal split, or use the mix method on this calculator: set the equal part to the cleaning fee’s share of the total.
Common questions
Does it work for utility bills when a housemate moved in mid-month?
Yes. Enter the number of days each person lived there in the month as their nights.
What if some people shared a room and others had their own?
Use points instead of nights: nights × a room factor for each person. Or split the rent itself with the rent by room size calculator.