Is there a way to compare dates from week to week?

[cherylincr]

We link several smaller schedules to a master schedule and I would lik
to compare the dates on the master schedule from one week to another t
see which dates have changed. The functional leads keep slipping date
without informing anyone and I want to find the tasks that have th
"finish" dates moved out without having to manually scour through tw
schedules

 

[Rod Gill]

Hi,

In the master schedule, save the baseline each week before project updates
are done. The Tracking Gantt Chart view will then show date changes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Dytham]

Or, as you may wish to preserve your main Baseline data, save an interim
baseline each week, eg. to Start10, Finish 10.

You can then use spare Text fields to contain a formula which calculates the
difference, in number of working days, between current dates and those in the
weekly baseline. eg:

IIf(Finish10<>ProjDateValue("NA"),ProjDateDiff([Finish10],[Finish])/480,"NA")

The If statement here avoids the value showing as an error for any tasks
added during the week.