Gap in dates if unique Id is the same

[olive2403]

Hi, is there is a formula that will help identify gaps between two dates for only rows that have the same unique Id?

Example:

Employee ID	Period Start Date	Period End Date
325456​	5/30/2008​	2/22/2014​
325456​	2/23/2014​	1/1/2016​
325456​	2/22/2016​	12/31/2021​
306914​	6/2/2014​	4/1/2016​
306914​	5/2/2016​	10/1/2016​
306914​	3/2/2017​	5/14/2018​

 

[Anthony47]

With the given example, which result would you like to get?