IluvPivots
Board Regular
- Joined
- Feb 13, 2007
- Messages
- 146
- Office Version
- 2016
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 |
