Hello,
How do I build a formula for my example attached to find the data gap and give me the start and end date?
Target Result:
Person A - First date Jan 1, 2018, Second date in consecutive would be January 9, 2018, and then there is a gap, so the second output would be January 21, 2018, and then there is a gap and the third output would be January 23, 2018 with the last output as Jan 30, 2018.
Thank you!!
