Greetings, iam Dorothy Ramos, Have an A+ day.

How Do You Find The Percentage Completed On A Date? [Solved]

Please use this formula: =MIN(1, (DATEDIF(B2,TODAY(),“d”)+1)/(DATEDIF(B2,C2,“d”)+1)). It will maintain it at 100% instead of 100 over percent if today date is exceed the end date.

Percentage of Completion Demonstration

Percentage

Calculate Percentage of Year Complete - Excel Formula

In this video, we calculate the

MS Project Planned Percentage Complete Vs Actual Percentage complete - Updated Improved version

Tutorial on how to create a customized field like Baseline planned