Hi.
Let me tell you what I'm looking for:
I need a formula that checks if the date in B6 matches any of the dates from the range on the right, and then returns "TRUE" if the column where the matching date is located also matches B4 (if the date is a Monday or a Wednesday) or B5 (if the date is a Tuesday or a Thursday). If it doesn't, I'd like for it to return "FALSE". If this is too hard or convoluted, I would also be happy with the formula if it doesn't check what the date is, as long as it matches either B4 or B5. Thanks for your help!
Book1.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Dragonfruit | Pear | Mango | Banana | Apple | Strawberry | Pomegranate | |||||
2 | ||||||||||||
3 | 10/31/22 | 10/31/22 | 10/31/22 | 09/29/22 | 10/31/22 | 09/26/22 | ||||||
4 | MON/WED | Strawberry | 02/03/23 | 12/05/22 | 03/16/23 | 10/31/22 | 02/03/23 | |||||
5 | TUE/THU | Banana | 03/16/23 | 03/17/23 | 03/17/23 | 12/05/22 | 03/16/23 | |||||
6 | 09/26/22 | 03/17/23 | 03/17/23 | 03/17/23 | ||||||||
7 | ||||||||||||
8 | ||||||||||||
9 | True or false? | |||||||||||
10 | ||||||||||||
Sheet1 |
Let me tell you what I'm looking for:
I need a formula that checks if the date in B6 matches any of the dates from the range on the right, and then returns "TRUE" if the column where the matching date is located also matches B4 (if the date is a Monday or a Wednesday) or B5 (if the date is a Tuesday or a Thursday). If it doesn't, I'd like for it to return "FALSE". If this is too hard or convoluted, I would also be happy with the formula if it doesn't check what the date is, as long as it matches either B4 or B5. Thanks for your help!