Return date of next instance

[IluvPivots]

Excel 2016. What would the formula be in the End date column? I want it to return the date of the next instance of "ENDDATE". The end date for week 10/5/2024 is 10/26/2024. See example column.

Date	Label	END DATE		Example of result
10/5/2024​				10/26/2024​
10/12/2024​				10/26/2024​
10/19/2024​				10/26/2024​
10/26/2024​	ENDDATE			10/26/2024​
11/2/2024​				11/30/2024​
11/9/2024​				11/30/2024​
11/16/2024​				11/30/2024​
11/23/2024​				11/30/2024​
11/30/2024​	ENDDATE			11/30/2024​
12/7/2024​				12/28/2024​
12/14/2024​				12/28/2024​
12/21/2024​				12/28/2024​
12/28/2024​	ENDDATE			12/28/2024​
1/4/2025​				2/1/2025​
1/11/2025​				2/1/2025​
1/18/2025​				2/1/2025​
1/25/2025​				2/1/2025​
2/1/2025​	ENDDATE			2/1/2025​

 

[HighAndWilder]

Wow!! Where has this formula been all my time in this job! Spectacular! Many thanks.

Glad it works for you. You don't need the 'label' column now.