Forum Discussion
Excel - how to use IF/AND/OR combo to see if a date range lies within another date range
I am trying to write a formula that will see if the acquired date (Column C) OR the sold date (Column D) lie within OR overlap the date range at G6:G7 and so on across the spreadsheet, an...
HansVogelaar thank you, that works for the "end" of each range, but doesn't capture the in between dates, which is the same problem I've been having, see screenshot.
The first line has the formula, the second is manually entered, which is what I am trying to get to, thanks again for the help!
- HansVogelaar that got it, thank you very much!!
