Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of Different Ranges Keeping Results In Sequential Columns | Excel Worksheet Functions | |||
How to create a sequential weekly date list, each separated by 5 r | Excel Worksheet Functions | |||
Date to TEXT. NOT to sequential serial number | Excel Discussion (Misc queries) | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
Calculate sequential value for future date | Excel Worksheet Functions |