How to find the beginning and end of a sequence

[TaskMaster]

Good morning,

I was wondering if anyone can assist me with the following query.

I have a date range in column A for days of the year and column B shows values of 1 or 0. Is there a formula that I can use that would tell me the start and end of a sequence where it shows 1's.

For example the output for the table below would be start 01/01/2022 End 02/02/2022, start 09/01/2022 end 10/01/2022.

Date	Active	Start	End
01/01/2022	1
02/01/2022	1
03/01/2022	0
04/01/2022	0
05/01/2022	0
06/01/2022	0
07/01/2022	0
08/01/2022	0
09/01/2022	1
10/01/2022	1
11/01/2022	0
12/01/2022	0
13/01/2022	0

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1	Date	Active	Start	End
2	01/01/2022	1	01/01/2022	02/01/2022
3	02/01/2022	1	09/01/2022	10/01/2022
4	03/01/2022	0
5	04/01/2022	0
6	05/01/2022	0
7	06/01/2022	0
8	07/01/2022	0
9	08/01/2022	0
10	09/01/2022	1
11	10/01/2022	1
12	11/01/2022	0
13	12/01/2022	0
14	13/01/2022	0
Lists

Cell Formulas
Range	Formula
C2:D3	C2	=LET(f,FILTER(A2:A14,B2:B14=1),INDEX(f,SEQUENCE(ROWS(f)/2,,,2)+{0,1}))
Dynamic array formulas.

 

[TaskMaster]

Hi Fluff,

Thank you for getting back to me so swiftly. As always you've absolutely nailed it, this is exactly what I was after!!!

 

[Fluff]

You're welcome & thanks for the feedback.