Cashflow - Date matching to return value

[E&E]

Hi all,

I cannot work this out at all, I would really appreciate your help.

The first image is my summary for June, so each day I want to be able to see how much I will be earning.

The second sheet shows the customers, how often their house is cleaned, the amount they pay and also the dates of their next 3 cleans. I'm only interested in Junes, and can adapt for other months.

I hope that makes sense with what I am trying to achieve.

Thank you in advance.

Attachment 522868

Attachment 522869