NON SEQUENTIAL DATE RANGES
On Jul 23, 2:42 pm, DebC wrote:
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-AB11,"Date Gap","")
To automatically insert a blank line you'll need code, not a formula.
|