Custom formula to compare Baseline Finish to Current Date

[mmtang]

Hi,

I know it's common to use the following formula to determine the
schedule of a project and was wondering if it makes sense to the
experts to change Finish to the current date. Does this make sense? I
don't know enough about PMI rules to understand what the impact is.

IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline",
IIf(ProjDateDiff([Baseline Finish],[Finish])/480>=20,"Late >20 Days",
IIf(ProjDateDiff([Baseline Finish],[Finish])/480>=10,"Late >10 Days",
IIf(ProjDateDiff([Baseline Finish],[Finish])/480>=5,"Late >5 Days",
IIf(ProjDateDiff([Baseline Finish],[Finish])/480>0,"Late >0 Days","On
Schedule")))))

Thanks!

 

[Dale Howard [MVP]]

mmtang --

Your formula is overly complex. Instead of using your DateDifff function in
your IIF statements, you can simply use the [Finish Variance] field, which
already calculates the difference between the current Finish date and the
Baseline Finish date.

When you say "change Finish to the current date" I have no idea what you are
talking about. Please explain.