If Condition with Dates

Hello
I have a very simple question related to IF function
I tried but failed in handling greaterthan equal to and less than equal to
Anyone will help me in this. Pic and given below and sheet attach for reference.
if anyone can help me to get result column with the help of if function

Screenshot_1.png