Formula: Ontime/late

[Gaetano_B]

Hi All, Happy Friday.

I'm trying to create a column (Completion Delta) which shows me whether a milestone was 'On Time' or 'Late' based on a date, as per example below.

Any Suggestions?

Target Completion Date	Actual Completion Date	Completion Delta
18/10/2020	19/10/2020	Late
18/10/2020	18/10/2020	On Time
18/10/2020	17/10/2020	On Time

[Emil_Kos]

H @Gaetano_B,

I have created a workflow for you:

The output:

Please mark it as a solution if this is something helpful!

Good luck!

[RolandSchubert · Accepted solution]

Hi @Gaetano_B ,

a formula using DateTime functions should do it:

IF DateTimeDiff(DateTimeParse([Target Completion Date], '%d/%m/%Y'), DateTimeParse([Actual Completion Date], '%d/%m/%Y'), 'days') >= 0 THEN
'On Time'
ELSE
'Late'
ENDIF

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[Gaetano_B]

Thanks @Emil_Kos  that works perfectly. Is there anyways we could add to the formula that if the actual completion date is blank then the completion delta should be blank?

I'll mark your post as a solution! Thanks again.

[Emil_Kos · Accepted solution]

Hi @Gaetano_B,

Sure that it is possible.

Please find solution attached.

[Emil_Kos]

Hi @Gaetano_B,

Thank you for marking my answer as a solution.

Good luck!