How to have a formula with if error

[aurelie_pilette]

Hello,

I have a field like "Sprint" in which the values can be  empty, Bugs à spécfier, Friday,  SprintXX.24-09/09-SFRA

I would like to create a caculated formula like : 

if sprint is not empty and != Bugs à spécifier or != Friday, DATE(2024, LEFT_TEXT(RIGHT_TEXT(Sprint, 13), 2), LEFT_TEXT(RIGHT_TEXT(Sprint, 10), 2)) else date is empty

So, do you know how can I make that please ?