Find Start and End Dates from a Block of Dates

[sbfernandes]

Greetings!

I am trying to find the start and end dates for StaffNo based on a sequence of consecutive dates.

From below table, StaffNo and Work_Date is the input. Output required from script is Start_Date, End_Date

StaffNo	Work_Date	Start_Date	End_Date
111	01-Jan-17	01-Jan-17	04-Jan-17
111	02-Jan-17	01-Jan-17	04-Jan-17
111	03-Jan-17	01-Jan-17	04-Jan-17
111	04-Jan-17	01-Jan-17	04-Jan-17
111	08-Mar-19	08-Mar-19	11-Mar-19
111	09-Mar-19	08-Mar-19	11-Mar-19
111	10-Mar-19	08-Mar-19	11-Mar-19
111	11-Mar-19	08-Mar-19	11-Mar-19
222	13-Apr-18	13-Apr-18	17-Apr-18
222	14-Apr-18	13-Apr-18	17-Apr-18
222	15-Apr-18	13-Apr-18	17-Apr-18
222	16-Apr-18	13-Apr-18	17-Apr-18
222	17-Apr-18	13-Apr-18	17-Apr-18
222	29-Dec-19	29-Dec-19	08-Jan-20
222	30-Dec-19	29-Dec-19	08-Jan-20
222	31-Dec-19	29-Dec-19	08-Jan-20
222	01-Jan-20	29-Dec-19	08-Jan-20
222	02-Jan-20	29-Dec-19	08-Jan-20
222	03-Jan-20	29-Dec-19	08-Jan-20
222	04-Jan-20	29-Dec-19	08-Jan-20
222	05-Jan-20	29-Dec-19	08-Jan-20
222	06-Jan-20	29-Dec-19	08-Jan-20
222	07-Jan-20	29-Dec-19	08-Jan-20
222	08-Jan-20	29-Dec-19	08-Jan-20

[alex00321 · Accepted solution]

Hi I use scripts to meet your requirements.

[sbfernandes]

Hi Alex00321

This works perfectly. Thank you very much.