Hi,
I need some help writing the right formula for my Cash flow forecast.
On the attached spread sheet,
Column A - Tenant's name
B - Tenancy start date
C - Tenancy end date
D - Monthly rent
E to T - Weekly dates
Rent is payable monthly from the first day of the tenancy. Based on the rent due dates, I want the rent amount to be slotted into the right date column in E-T.
For example, tenant A's first instalment will be due on 30/7/20 and therefore, £706 should be in E5 as it falls in the week commencing 27/07/2020. The 2nd instalment will be due on 30/08/2020 and therefore should be in column I.
Please help!
Thank you
Mathanki
Bookmarks