% complete, can it be calculated based on today's date?

So I want to know if % completed can be populated automatically based on today's date? If so how can I do that ?

Thank you


  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    This is very dependent on how you have your sheet setup. Here is a simple version of what I believe you are asking:

    The formula for [Percent of Completion] is:

    =IF(AND(ISDATE([Start Date]@row), ISDATE([End Date]@row)), IF([End Date]@row <= TODAY(), 1, IF([Start Date]@row > TODAY(), 0, (NETDAYS([Start Date]@row, TODAY())) / (NETDAYS([Start Date]@row, [End Date]@row)))))