In this video, we're going to show you how to calculate the planned percentage in Microsoft Projects. If you're a project manager or just someone who uses Microsoft Projects for tracking and planning your projects, this tutorial is for you. We'll take you through a step-by-step process on how to set up and calculate the planned percentage of your project, which is a key metric for measuring project progress. Whether you're a beginner or an experienced user, this video is sure to enhance your understanding of Microsoft Projects and help you track your projects with ease. So, grab a pen and paper and let's get started!"

Here are some of the formulas we share in the video:

Simple Number Formula (Note this will not yield accurate % complete results): 

IIf([Baseline Estimated Finish]<=[Status Date],1,IIf([Baseline Estimated Start]>[Status Date],0,ProjDateDiff([Baseline Estimated Start],[Status Date])/ProjDateDiff([Baseline Estimated Start],[Baseline Estimated Finish])))

Correct % complete formula for MS Project:

Number1 - Baseline Duration Total - Must be a Number field, must Sum the roll-up headings.
IIf([Duration]=0,0.01,ProjDateDiff([Baseline Estimated Start],[Baseline Estimated Finish]))

Number2 - Baseline Days Completed - Must be a Number field, must Sum the roll-up headings.

IIf([Baseline Estimated Finish]<=[Status Date],[Baseline Duration],IIf([Baseline Estimated Start]>[Status Date],0,ProjDateDiff([Baseline Estimated Start],[Status Date])))

Number3 - Planned Completion value - Must be a Number field

IIf([Baseline Estimated Finish]<=[Status Date],1,IIf([Baseline Estimated Start]>[Status Date],0,[Number2]/[Number1]))

Text1 - Round([Number3]*100) & "%"

If you like to know more about our Microsoft Projects for Construction and Engineering Professionals, see below:

Subscribe to receive our monthly articles

Sign Up For Our News Letter