View Single Post
 
Old 01-26-2022, 10:24 AM
tdeogburn tdeogburn is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2022
Posts: 5
tdeogburn is on a distinguished road
Default 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
Reply With Quote