Susannah68
New Member
- Joined
- Oct 6, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I'm trying to find a formula which will identify a date range within a data range. My example is trying to identify whether the date range in columns A and B contains the date range in B2:C2. ie do the dates in columns A & B contain any part of 2021
Apologies if the solution is out there, but I've tried various formulas and none seem to work right. I've included an example where the start date and end date both fall outside of 2021.
Thank you
Apologies if the solution is out there, but I've tried various formulas and none seem to work right. I've included an example where the start date and end date both fall outside of 2021.
Thank you