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
Bookmarks