View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DebC DebC is offline
external usenet poster
 
Posts: 39
Default 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.