+ Reply to Thread
Results 1 to 2 of 2

Combine multiple enrollment dates to identify breaks / continous coverage

  1. #1
    Registered User
    Join Date
    04-05-2017
    Location
    St. Joseph, MO
    MS-Off Ver
    2016
    Posts
    1

    Combine multiple enrollment dates to identify breaks / continous coverage

    I have an excel sheet that has the enrollment dates for an employee. However, do to status changes, the employee may have multiple start / stop dates that are on different rows. Is there a macro or formula that will look at the detail and give the full start / stop date or identify when there is a trued break? Below is an example of the data:

    EMPLOYEE EMPLOYEE.LAST-SUF EMPLOYEE.FIRST-NAME PLAN-CODE START-DATE STOP-DATE
    12345 Smith John PERM 01/01/2019 02/20/2019
    12345 Smith John PERM 02/21/2019 03/06/2019
    12345 Smith John PERM 03/07/2019

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,899

    Re: Combine multiple enrollment dates to identify breaks / continous coverage

    Hello and welcome to the forum.

    I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 09-19-2014, 03:47 PM
  2. Replies: 1
    Last Post: 09-18-2014, 05:17 PM
  3. Combine cells of portions of a numbered list into a continous numbered list
    By AusTempest in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2014, 01:55 AM
  4. Charting multiple dynamic ranges as a single continous series
    By ks26 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-13-2014, 12:30 PM
  5. vba print continous with paper continous and epson LQ300?
    By heroic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2013, 03:22 AM
  6. Replies: 2
    Last Post: 05-22-2013, 12:38 PM
  7. Set Multiple (non-continous) ranges for easy Copy then paste values
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2011, 08:48 PM

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