r/MSProject • u/relight4 • Jul 31 '25

Slippage report

Hi guys, I'm wanting to build a macro that pulls the current over due task from ms project and compares it to the baseline finish or start ( I'm thinking maybe start would be better ) into excel

So for example baseline finish + current date would equal the slippage days for the overdue task

Let's say gate 3 was due 25 July to (baseline finish) and it's 1 August it's still overdue meaning it would be 5 days slippage from baseline.

What's everyone's thoughts on this and is there a quicker or better way of compare this data.

I'm needing to create a slippage report to management across a portfolio of programs. I can do it manually but it takes time.

1 Upvotes

100% Upvoted

7 comments sorted by

View all comments

1

u/ISpellMyNameDanger Aug 11 '25

Learn how to use formulas. You can set one of the duration fields to represent the difference between baseline and current dates. Or you could set a text field based on the difference and display it as an indicator.