Count and Sum Automaticly in specific Date

Hi all, i am struggling to finish this spreadsheet, can you one help please, i have try my best to explain details in this picture i post below.

If any one have ideas to do that, please help..

Thanks