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...
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.