Calculating task % Complete based on todays date

Dan Harris

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

Thanks

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!