I think you mean something like this ?
if yes, the formula is the following :
=IF(B2<=TODAY();"Yes";"No")