Calculating task % Complete based on todays date

Is there a formula available to calculate % complete a task should be completed, based on todays date?

Thanks

Tags:

Answers

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    Hi Dan,

    Your formula should look like something like this:

    =(TODAY()-[Start Date]@row)/([End Date]@row-[Start Date]@row)

    You can replace the (End Date - Start Date) by the duration column which should give the same result.

    You can add some IF statement at the beginning to check if [Start Date] is in the future or not, to return 0.

    Also make sure that Start and End aren't the same date, otherwise you'll have some divide by zero.


    Hope it helped!