Behind/Ahead of Schedule by "x" days

Elizabeth Jones

Hi All,

I'd like to add a column that reflects how many days my project plan is ahead/behind schedule. I asked this question last year, but couldn't find it anywhere.

I have a Planned Finish and a Finish Date.

I'd like the row to display the following for each:

1. If no variance, display "On Time"
2. If late, display " X days Late"
3. If early, display "X days Ahead".

Thanks!

Paul Newcome

Try something like this...

=IF([Finish Date]@row > [Planned Finish]@row, [Finish Date]@row - [Planned Finish]@row + " days Late", IF([Planned Finish]@row > [Finish Date]@row, [Planned Finish]@row - [Finish Date]@row + " days Ahead", "On Time"))

Paul Newcome

Try something like this...

=IF([Finish Date]@row > [Planned Finish]@row, [Finish Date]@row - [Planned Finish]@row + " days Late", IF([Planned Finish]@row > [Finish Date]@row, [Planned Finish]@row - [Finish Date]@row + " days Ahead", "On Time"))

Elizabeth Jones

Beautiful! thanks so much :)

Paul Newcome

Happy to help! 👍️

Sandra Guzman

I am glad that I found this discussion - it's exactly what I was also looking for!

I am using the above formula and wanted to know what I would need to adjust in the formula so that the field is blank until the End date is entered. I replaced @row and entered the row number... but each formula I used still displays "day Ahead" in each field where a task has not yet been started. I want to try to avoid having text in these fields.

Thanks!

Sandra

Paul Newcome

@Sandra Guzman

Try something like this...

=IF([End Date]@row <> "", above formula)

This will only run the above formula if the End Date is not blank.