Dear all experts here,
How should I draft my IF Statement here if I am looking to label "Yes" and "No" if it match the date in Column B. 
CodePudding user response：
use:
=ARRAYFORMULA(IF((A2:A29>=B2)*(A2:A29<B3), "Yes", "No"))
Dear all experts here,
How should I draft my IF Statement here if I am looking to label "Yes" and "No" if it match the date in Column B.
CodePudding user response：
use:
=ARRAYFORMULA(IF((A2:A29>=B2)*(A2:A29<B3), "Yes", "No"))