IF Function on dates to change status

[Maz_0102]

Hi

I am trying to create a column using the below if fuction

however i cant get the rows set to in progress

if the due date > today's date i want it returned to "In Progress"

Am i doing the formula wrong?

Column = IF('PPM''s'[Open Days from/to Due Date Status]="Complete",IF('PPM''s'[Job_Finish_Date]>'PPM''s'[Job_Due_Date],"Complete - Late",IF('PPM''s'[Job_Finish_Date]<='PPM''s'[Job_Due_Date],"Complete - On Time",IF('PPM''s'[Job_Due_Date] > 'PPM''s'[Today's date],"In Progress",""))))

[ManguilibeKAO]

Hi,

Could we have input data (or at least four or five rows in the input), and the output you want?

Best regards.