Results 1 to 8 of 8

Identifying dates that are not included

Threaded View

leslieharris Identifying dates that are... 08-11-2012, 11:11 AM
Pepe Le Mokko Re: Identifying dates that... 08-11-2012, 02:48 PM
leslieharris Re: Identifying dates that... 08-11-2012, 05:44 PM
FDibbins Re: Identifying dates that... 08-11-2012, 03:33 PM
FDibbins Re: Identifying dates that... 08-11-2012, 05:56 PM
leslieharris Re: Identifying dates that... 08-11-2012, 09:25 PM
FDibbins Re: Identifying dates that... 08-12-2012, 07:42 PM
leslieharris Re: Identifying dates that... 08-14-2012, 08:17 AM
  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2003
    Posts
    12

    Identifying dates that are not included

    I am trying to identify gaps in coverage for insurance. Even if there is a 1 day gap, I would like to identify that person in Column D by indicating "Gap in coverage".

    For example, Joseph's coverage years are 7/7/11 to 7/6/12 (Row 2), 5/12/10 to 5/11/11 (Row 4), 7/7/12 to 7/6/13 (Row 5) and 5/12/09 to 5/11/10 (Row 7). Joseph has had continuous coverage except between 5/12/11 to 7/6/11. I would like Column D to indicate when the person had a lapse in coverage. Please assist with a simple formula - thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1