Hi, good afternoon,

I’m trying to create a table which calculates the monthly rental for equipment.

For example: the daily rent for the equipment is 10€/day.
Customer A has lent 1 equipment starting on the 27th of April, Customer B has lent 1 equipment starting on 25th of April and he did return it at 10th of June. So at this moment the current outstanding rental is:
A: 40€ in April, 310€ in May and 180€ in June
B: 60€ in April, 310€ in May and 100€ in June

Can someone help me out with the formula?

Thank you!, Kind regards,

Knipsel.PNG