• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding percentage from Start Date, Committed Date and Completion Date

G

Gopinath Raghav

New Member
Hi All,

I want to calculate the percentage from Start Date, Committed Date and Completion Date by giving multiple conditions, which I tried by myself only to get stuck and not move any further.

I am attaching a sample file for reference.

Kindly let me know if there is any other way to solve it.

Warm Regards,
Gopi
 

Attachments

  • Days Percentage.xlsx
    17.1 KB · Views: 8
What is your expected result and the logic you are following? Your formula is a div by zero, so that logic is off so to speak.

- When completion date is filled is it's 100%?
- The denominator is Committed - Start? The period in which it needs to be finished?
- The numerator is what then? What if today is > committed and no completion is filled?
- Can you go over 100%? Then it's delay?

Maybe add some more use cases in your example so that every scenario for which you are seeking a result is covered by the potential solution.
 
=(([@[COMPLETION DATE]]-[@[START DATE]])/([@[COMMITTED DATE]]-[@[START DATE]]))-1
and format as a perentage?
 
You must log in or register to reply here.
Back
Top