Can planned percentage be calculated using Status Date?

This video shows the calculation of planned percentage using Project Status Date.
Status Date in a project is used for project progress and earned value calculations.
===================================================================
MS Project Playlist in English :
www.youtube.co...
===================================================================
MS Project Playlist in URDU / HINDI:
www.youtube.co...
===================================================================
MS Word Playlist in English :
www.youtube.co...
===================================================================
MS Word Playlist in URDU / HINDI:
www.youtube.co...
===================================================================
MS Excel Playlist in English :
www.youtube.co...
===================================================================
MS Excel Playlist in Urdu / Hindi:
www.youtube.co...
===================================================================
===================================================================
MS PowerPoint Playlist in English :
www.youtube.co...
===================================================================
MS PowerPoint Playlist in URDU / HINDI:
• Microsoft PowerPoint T...
==================================================================
Facebook :
/ sameer.muham...​
===================================================================
Instagram:
/ ​
===================================================================

[@dimitargyoshev5896]

Very good update of your previous video for the NOW() date. Now you can choose the TODAY date as the Status Date and its gives the same results as in the previous video. Am I correct? Thank you!

[@SMJTech2020]

Yes, that is correct. Thank you for sharing this information

[@EngrArif-it6mv]

IIf([Status Date][Finish],"100",Int(ProjDateDiff([Start],[Status Date]+1,[Project Calendar])/[Duration]*100))) & "%"

[@mfirdausah]

Hi Sir, i have used the formula but i realize the planned % of my Group summary rows are not the same as per Actual % despite all sub-task are in the same percentage between Actual vs Planned. By any chance you any idea on this matter?

[@SMJTech2020]

Hi Firdaus, the reason for seeing the difference is that the actual completion percentage uses a different formula for calculation as compared to the planned completion formula. Since the parameters for both are different, you will see different values

[@masinagudi2564]

@@SMJTech2020 - How we can make the actual % and planned % fix at the summary level?

[@MukunthanIyer]

How difficult is it to put the formula in the comments, dear? Doesn't take a genius to do that.

[@SMJTech2020]

Hey there, if you watch the video closely the formula is already there. 🙂

[@MukunthanIyer]

Ctrl C + Ctrl V. 🤷