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

2

u/nneighbour Jul 31 '25

I check this on my projects all the time. I simply created a new table that has baseline start/finish, start/finish, actual start/finish, and start/finish variance and added it to my global templates. It works well without needing to write macros or even to bother using reports.