I have a set of data that is a list of time periods. Some of these time periods overlap, and they are not sequential (one does not necessarily precede the next). I need to identify if there are any gaps in time greater than 6 months.



Is there a quick way to identify if there is a gap? Here is an example of the time periods I am dealing with:

06/2019-Present
09/2011-10/2020
03/1998-04/2002
03/1998-02/2012

Please post a sample sheet with some data and manually calculated expected results. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

See attached. I am trying to clearly highlight gaps in time greater than 3 months, however, the time periods are not end to end (can overlap).
Thank you!

Attached Files

Affiliaiton Audit Test.xlsx (8.5 KB, 6 views)