Hi, guys.
The problem is long to explain. I tried to copy a sheet using XL2BB but it copies nothing, so I'm posting a screenshot.
I have a date in cell B6 (Sept 26th, which is Monday). I need to know if the date comes up in the table on the right (which it conveniently does, under the Strawberry column). However,, since Strawberry is marked as a Monday or Wednesday only item, I need a formula that returns "TRUE" only if the date in B6 is either a Monday or a Wednesday. Now, if I change the date to 09/29/22 (which is Thursday), since the Banana column also contains that date, I need it to return "TRUE" as well.
In short, I need a formula that first checks if my date is either a Monday/Wednesday or a Tuesday/Thursday, and then tries to check if my date is in the corresponding fruit column. If it is, return "TRUE". If it isn't, return "FALSE".
Let me know if I didn't explain my problem well enough. Thanks!
The problem is long to explain. I tried to copy a sheet using XL2BB but it copies nothing, so I'm posting a screenshot.
I have a date in cell B6 (Sept 26th, which is Monday). I need to know if the date comes up in the table on the right (which it conveniently does, under the Strawberry column). However,, since Strawberry is marked as a Monday or Wednesday only item, I need a formula that returns "TRUE" only if the date in B6 is either a Monday or a Wednesday. Now, if I change the date to 09/29/22 (which is Thursday), since the Banana column also contains that date, I need it to return "TRUE" as well.
In short, I need a formula that first checks if my date is either a Monday/Wednesday or a Tuesday/Thursday, and then tries to check if my date is in the corresponding fruit column. If it is, return "TRUE". If it isn't, return "FALSE".
Let me know if I didn't explain my problem well enough. Thanks!