Returning data based on two columns

Summary

Data must be returned if either of the criteria satisfied

Content

HI all

Any ideas how to do the above.

I am working in Absence Calendar and have the start and end dates of the absence however the prompt must include the data if any of the dates between the start date and end date fall between the prompt dates.

e.g. the prompt dates are 01/01/20 and 31/01/20

Person 1 has an absence that started on 31/12/19 and has no end date - Included

Person 2 has an absence that started on 31/12/19 and ended on 31/12/19 - Not included

Person 3 has an absence that started on 31/01/20 and has no end date - included