Find results base on remarks & date

[Fenfen Gao]

Hi I have one data that want to find out the results base on remarks data and date that we have, have trying many formula but still not working, Please help  :(

i have upload sample file.