A asowdi New Member Apr 22, 2012 #1 Can anyone help me to find the percentage of completion of task? I have task with "start date" and "end date". I want to calculate percentage of completion of task as on today’s date.
Can anyone help me to find the percentage of completion of task? I have task with "start date" and "end date". I want to calculate percentage of completion of task as on today’s date.
N NARAYANK991 Excel Ninja Apr 22, 2012 #2 Hi Ashwin , The percentage completion as on date , given a start date and an end date , would be : 100 * (Today's date - Start Date)/(End Date - Start Date) Narayan
Hi Ashwin , The percentage completion as on date , given a start date and an end date , would be : 100 * (Today's date - Start Date)/(End Date - Start Date) Narayan
Hui Excel Ninja Staff member Apr 22, 2012 #3 Ashwin The percent complete is (today - start date)/(End date- Start date)