Date Range Gaps Example

[cchueh]

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!!

[echuong1]

You can use multi-row formulas to create flags if there is a gap. From there, you can filter for the flags, reassign IDs, and pivot the data back.

See attached. Let me know if this is what you're looking for.

[cchueh]

@echuong1  Would you be able to re-send the workflow in .yxmd format? For some reason I can't open  your .yxzp format of workflow. Apologies for the inconvenience.

Thank you so much!

[echuong1 · Accepted solution]

See attached! You'll need to configure the input tool to the correct path on your computer.

[cchueh]

@echuong1 Thank you so much!!