Forum Discussion

Copper Contributor

Sep 05, 2021

Solved

excel multiple and/or conditions with date data

I am able to retrieve data from D2 and E2 but I also want to have the same data included with D3 and E3 also. Is it possible to get multiple "date" data from Excel? Example below:

excel

Formulas and Functions

HansVogelaar
Sep 05, 2021
ardamutlu

How about

=IF(OR(AND(A2>=$D$2;B2<=$E$2);AND(A2>=$D$3;B2<=$E$3));"true";"false")

ardamutlu

Copper Contributor

Sep 05, 2021

HansVogelaar Hi!

I have tried it, but It gave me all of the data as "true".
For example: As you can see from the image, I want the red ones to be "false" because, they are not included between (01.03.2022/30.04.2022 and 01.06.2022/31.08.2022). I want to have the ones that belong inside that two certain dates as "true" not all of them.
I am wondering if it's possible to do such thing in Excel or not.

HansVogelaar

MVP

Sep 05, 2021

ardamutlu

How about

=IF(OR(AND(A2>=$D$2;B2<=$E$2);AND(A2>=$D$3;B2<=$E$3));"true";"false")

ardamutlu
Copper Contributor
Sep 05, 2021
HansVogelaar

Perfect! It works out just fine.

Thanks a lot! You are the best.