Identify Gaps in Time Periods (non-sequential)
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
|