Forum Discussion
Solved
check if multiple dates are in multiple date ranges
Hello guys, can you please help me with an ideea about this problem that I'm facing for a project please? I need an formula that checks if these given dates are included in the date ranges (from th...
I don't understand. The 1st of January is included in the range from 25th December 2021 to 5th January 2022.
Hello Hans.
thank you for your message. It is right. I've forgot to change the range 25 dec to 5 jan in order to match my example. I've edited my initial post right now and displays the right content. Sorry for that.
The problem here is that a logical function can't be dragged downwards in order to change the references from another cells automatically. It will work only if I edit row by row manually.
Please let me know if you have any questions in order to clarify them and find an solution.
thank you for your message. It is right. I've forgot to change the range 25 dec to 5 jan in order to match my example. I've edited my initial post right now and displays the right content. Sorry for that.
The problem here is that a logical function can't be dragged downwards in order to change the references from another cells automatically. It will work only if I edit row by row manually.
Please let me know if you have any questions in order to clarify them and find an solution.
- HansVogelaar
one question please
how can I use the formula that you've provided: =SUMPRODUCT((AG3>=AH$3:AH$21)*(AG3<=AI$3:AI$21))>0
with an IF statement?
example: IF value of of an cell A1=TRUE than do the SUMPRODUCT.
looks like it's not working=IF(A1,SUMPRODUCT((AG3>=AH$3:AH$21)*(AG3<=AI$3:AI$21))>0)
or perhaps
IF(A1,SUMPRODUCT((AG3>=AH$3:AH$21)*(AG3<=AI$3:AI$21))>0,"")
- HansVogelaar
many thanks. You saved my deadline 🙂 much appreciated
I will leave this post open for a few more hours in case something else happens.
Wish you all the best!