if, not - help needed please excel formula

I am sorry if this seems very simple but I am struggling , my hausnab used tio help me but he passed away during pandemic so I am fighting to do this  I use this to tell me if date is a thusday to b...