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

rbaechel

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

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