Date Duration and Output datewise

I have excel sheet where I have Projected Receivable amount with Projected Date as well as I have actual Cash Received with actual date but I am unalbe to get inforamation weekwise that how much cash I am going to receive in this week or next week or upto specific date and same about actual means how much cash I actualy received in this week or up to specific date. I dont want to change columns into rows or rows into columns.

Please find attached file for clear idea

Waiting for reply

This is one solution (quite flexible).
Though it goes against "I dont want to change columns into rows ....".
//Ola