Formula to check if date range falls within another date range
I am trying to determine if a date range falls within another date range for a specific ID.
Example:
Table1
IDStart DateEnd Date110/9/202211/19/202222/12/20233/11/2023
Table2
IDStart DateEnd DateValue110/10/202211/10/2022Leave25/5/20245/21/2024Leave
Expected Result
IDResult1Leave2(blank)
I am trying to determine if a date range falls within another date range for a specific ID. Example: Table1IDStart DateEnd Date110/9/202211/19/202222/12/20233/11/2023Table2IDStart DateEnd DateValue110/10/202211/10/2022Leave25/5/20245/21/2024LeaveExpected ResultIDResult1Leave2(blank) Read More
