Text to Date formula

Hi all 

I have a text field with data in this format Friday, 24 November 2023. My expectation from the below format is dd/mm/yyyy i.e. 24/11/2023 

I am getting a NULL value with the below formula, what am I missing? 

DATE( VALUE(RIGHT({!$Record.OEM_Order_Acceptance_Date__c}, 4)), IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "January"), 1,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "February"), 2,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "March"), 3,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "April"), 4,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "May"), 5,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "June"), 6,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "July"), 7,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "August"), 8,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "September"), 9,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "October"), 10,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "November"), 11,

IF(CONTAINS({!$Record.OEM_Order_Acceptance_Date__c}, "December"), 12,

)))))))))))),

VALUE(

MID(

{!$Record.OEM_Order_Acceptance_Date__c},

FIND(",", {!$Record.OEM_Order_Acceptance_Date__c}) + 2,

FIND(" ", {!$Record.OEM_Order_Acceptance_Date__c}, FIND(",", {!$Record.OEM_Order_Acceptance_Date__c}) + 2)

- FIND(",", {!$Record.OEM_Order_Acceptance_Date__c}) - 2

)

)

) 

Hope you can help 

LJ