IF Statement if it match range of data

user_18724975 0
Viewed 30

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. Here is the trix

enter image description here

google-sheets-formula google-sheets if-statement filter arrays
1 Answers

use:

=ARRAYFORMULA(IF((A2:A29>=B2)*(A2:A29<B3), "Yes", "No"))

enter image description here

user_56326290
Related