Calculating task % Complete based on todays date


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




  • 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!