How could the value attached to a specific date falls into the corresponding month

Hi guys,

I have a table where shows the 5 review dates and r5 eviewed yearly rent income for each tenant. I'm trying to pupulate the reviewed yearly rent charge into the corresponding month column (AH: CR), where list the date range by month from Apr12-Mar17. Eg. First Review Date is 01/08/2012, reviewed rent is $20,813; Second Review Date is 01/08/2013, reviewed rent is $21,645. Is there a formula that could automatically populate $20,813 under Aug-12 column and $21,645 under Aug-13 column?

Many thanks!