Custom Formula - help

[Jason]

I'm trying to develop a custom formula for late tasks, but have little
expereince in this area. I need on sched, behind sched, and over 2 weeks
sched. I believe what I can't fingure out is the over 2 weeks piece
(calculation).

IIf((([Task Baselined?]="Baselined") And ([Baseline Finish]<[Finish])),"Task
Behind Schedule",IIf((([Task Baselined?]="Baselined") And ([Baseline
Finish]=[Finish])),"Task On Schedule",IIf((([Task Baselined?]="Baselined")
And ([Baseline Finish]<[Finish])),"Over Two Weeks",IIf([Task Baselined?]="No
Baseline","Task Not Baselined","Calculation Error"))))

Jas

 

[Jonathan Sofer]

You can do a datediff comparison of [Baseline Finish] and [Finish] to see if
it is > than two weeks. The datediff syntax can be found in the formula
screen under the available functions. Also be aware that the datediff
probably excludes weekends if you are using a base calendar and so two weeks
might not be 14 days bur rather 10 days or something else depending on when
the dates land. These are things you will have to verify.

Jonathan