Days behind schedule

[DennisJarz]

Is it possible to have a calculated field showing then number of days that a task is ahead of or behind schedule?

For instance a tasks duration is 10 days long. The task started 5 days ago and the task if 60% complete. The field should show 1 day ahead of schedule.

 

[PDQBach]

Which version of Project are you using?

 

[DennisJarz]

Microsoft Project 2000

 

[PDQBach]

If this had been P98 then you'd have needed VBA.

Why didn't you create an equation in one of the calculated fields?

Insert the field Number1.
RightMouseButton on the column header
Click on Customize Fields ...
Click on the Formula button and paste this in:

int((ProjDateDiff([Start],[Finish])/480)*([% Complete])/100)-int(projdatediff([Start],now())/480)

(The equation wraps so be careful when you paste it in.)

It's not a particularly useful number (in fact, it's almost totally useless) but now you know how to generate it.