0

I need to calculate the current date in relation to the start and end dates of a task and would expect to see a field that shows the completion percentage. Something like this Question or this explanation (today - start date)/(End date- Start date).

Improve this question
3
  • I removed your second question. If you have a second question, you should ask it in a separate Question, linking if necessary.
    – Sarov
    May 8, 2018 at 13:12
  • They are linked with each other so I put them together
    – oCcSking
    May 8, 2018 at 13:24
  • 1
    Your call if you want to add it back, but it seemed to me that the two questions could each be answered in isolation.
    – Sarov
    May 8, 2018 at 13:32

1 Answer 1

Reset to default
1

To calculate the percentage of a task that should be done based on the current date and working time (e.g. the project calendar), customize a number field with this formula:

IIf( [Start] > Date(), 0, IIf( [Finish] < Date(), 1, ProjDateDiff( [Start], Date()) / [Duration]))

Note: answer was updated to reflect OP's correction to handle future tasks.

Improve this answer
1
  • 1
    thanks !-) I customized a text field with 100 * IIf( [Start] > Date(), 0, IIf( [Finish] < Date(), 1, ProjDateDiff( [Start], Date()) / [Duration])) & "%"
    – oCcSking
    May 9, 2018 at 8:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.