if Condition match with Date function

Hi There,

Assigned if condition formula with matching the date function, but getting error or getting wrong result. is there way out to fix this? attached excel file

Thanks in Advance.. Senthil