NON SEQUENTIAL DATE RANGES

[DebC]

Is there a way to split out non-sequential dates in a column of dates? For
example I have listed for a single client service dates of Jan 1-5, Mar 3-11,
July 5-10 and then would have the non sequential dates for other clients. I
need a simple blank line (or any other way of indicating) when a client has
multiple admissions which will be known by the fact they have multiple
non-sequential ranges of dates in a column.

 

[Spiky]

Is there a way to split out non-sequential dates in a column of dates? For
example I have listed for a single client service dates of Jan 1-5, Mar 3-11,
July 5-10 and then would have the non sequential dates for other clients. I
need a simple blank line (or any other way of indicating) when a client has
multiple admissions which will be known by the fact they have multiple
non-sequential ranges of dates in a column.

To simply see it you could make a helper column, or use conditional
formatting with something like this:
=IF(AB2-AB1>1,"Date Gap","")

To automatically insert a blank line you'll need code, not a formula.