NON SEQUENTIAL DATE RANGES
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. |
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. |
All times are GMT +1. The time now is 05:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com