compound if formula

Hi
I wrote the formula below to checks the status of moderation based on the ‘Moderation Completed’ and ‘Moderation Due Date’ columns. If ‘Moderation Completed’ is ‘Yes’, it returns ‘Completed’. If the due date is past and ‘Moderation Completed’ is ‘No’, it returns ‘Overdue’. If the due date is today or in the future and ‘Moderation Completed’ is ‘No’, it returns ‘Date yet to come’. Otherwise, it returns nothing.
It currently returns invalid formula, I really appreciate it if anyone could help me understand why it is not working and how to fix it, thank you
IF({Moderation Completed} = “Yes”, “Completed”,
IF(AND(FORMAT_DATE({Moderation Due Date}, “DD/MM/YYYY”) < FORMAT_DATE(TODAY(), “DD/MM/YYYY”),{Moderation Completed}=“No”), “Overdue”, IF(AND (FORMAT_DATE({Moderation Due Date}, “DD/MM/YYYY”) >= FORMAT_DATE(TODAY(), “DD/MM/YYYY”),{Moderation Completed}=“No”), “Date yet to come”, “” )))