Nested IF

KarineMul22_TPg

Hello,

This formula used to work when finishing in December, I have just added some IFs to extend to March but it comes back with #UNSPEARABLE and I keep looking at it in vain, cannot find the error - can anybody help please?

=IF([PM - Revised build start date]@row < DATE(2023, 11, 1), "2023-10-CTB",

IF([PM - Revised build start date]@row < DATE(2023, 12, 1), "2023-11-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 1, 1), "2023-12-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 2, 1), "2024-01-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 3, 1), "2024-02-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 4, 1), "2024-03-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 5, 1), "2024-04-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 6, 1), "2024-05-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 7, 1), "2024-06-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 8, 1), "2024-07-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 9, 1), "2024-08-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 10, 1), "2024-09-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 11, 1), "2024-10-CTB",

IF([PM - Revised build start date]@row < DATE(2024, 12, 1), "2024-11-CTB",

IF([PM - Revised build start date]@row < DATE(2025, 1, 1), "2024-12-CTB",

IF([PM - Revised build start date]@row < DATE(2025, 2, 1), “2025-01-CTB”,

IF([PM - Revised build start date]@row < DATE(2025, 3, 1), “2025-02-CTB”,

“2025-03-CTB")))))))))))))))))

Many thanks

Karine