Automatically calculate % Complete based on Dates

mcbach2

Request to improve % Complete column formula.

1. Currently provided % Complete column formula will never be accurate if you also have identified Milestones since Milestones are only identified if Duration = 0, so % Complete will never show 100% for the associated Parent Rows.
2. Currently provided % Complete column/column formula not sophisticated enough to calculate % complete for child rows based on the tracked Start Date and End Date. For example:
   1. If Start Date is a future date set % Complete to 0
   2. If Start Date is >=Current Date calculate % Complete based on the Duration
   3. If End Date is in the past set % Complete to 100%.