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).

  • 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 '18 at 13:12
  • They are linked with each other so I put them together – oCcSking May 8 '18 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 '18 at 13:32

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
    thanks !-) I customized a text field with 100 * IIf( [Start] > Date(), 0, IIf( [Finish] < Date(), 1, ProjDateDiff( [Start], Date()) / [Duration])) & "%" – oCcSking May 9 '18 at 8:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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