Two dates (w/ Todays date in mind) and % actual Progress = % complete

All,

I am looking for a function to calculate actual percent completion.

Example Variable:
assuming today is 10.05.2020

1. Start Date: 8/31/2020
2. End Date: 12/01/2020
3. Teammates entered Progress: 65%
4. =?

I currently have a function that includes start, end date, and todays date to get a completion result. However... It does not incompass the actual progress completed progress (4.). AND if a date is over todays date my percent goes past 100%....
{=(DATEDIF(D5,TODAY(),"d")+1)/(DATEDIF(D5,E5,"d")+1)}

Any help with a function layout would be great to reach my goal of #4

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

My understanding is that you don't want the formula to display a percentage greater than 100%. If that is the case then try:

Formula:

Please Login or Register  to view this content.

If I am missing something then please give us some further explanation and possibly manually calculate some of the results so that we have values with which to compare the output of our formula/code proposals.
Let us know if you have any questions.