Sep 05 2021 11:47 AM
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:
Sep 05 2021 12:02 PM
I'm not sure I understand what you're trying to do, but perhaps
=IF(AND(OR(A2>=$D$2;B2<=$E$2);OR(A2>=$D$3;B2<=$E$3));"true";"false")
Sep 05 2021 12:51 PM
@Hans Vogelaar 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.
Sep 05 2021 12:55 PM
SolutionSep 05 2021 12:59 PM
Sep 05 2021 12:55 PM
SolutionHow about
=IF(OR(AND(A2>=$D$2;B2<=$E$2);AND(A2>=$D$3;B2<=$E$3));"true";"false")