Hello, I wanted to create an excel/portfolio of rooms, that I'm renting out (I.e. two houses, 2 rooms upstairs, 3 downstairs) but I don't know how to program the calculations.
For example;
House - Room - Tenant entry date - Tenant Leaving date - Rent -

..etc
Then having the overall value for all rent, turned into a large revenue amount.

would you be able to help me with his formula?

James