Using date format in the cells how determine percent complete
 

I have 8 steps to a particular activity. I need to show the dates each step
is completed but I also need to determine the percent complete of the overall
activity. Any suggestions would be greatly appreciated.

Using date format in the cells how determine percent complete
 

If the overall start and finish dates are in A2 and I2, then if you have,
for example the 4th step, which runs from E2 to F2, the percentage of the
total is
=(F2-E2)/(I2-A2) formatted as a percentage.
--
David Biddulph

"boiseman62" wrote in message
...
I have 8 steps to a particular activity. I need to show the dates each step
is completed but I also need to determine the percent complete of the
overall
activity. Any suggestions would be greatly appreciated.

Using date format in the cells how determine percent complete
 

hi
not sure what you are asking but...
percent is calculated as a portion compared to the total.
8 steps in the total so each step would be 12.5%.
if your are trying to calculate the percent based on date then you would
have to know the end date to calculate a percent.
end date - start date = total time.
then the start date would have to be subtracted from each ste[ end date and
then devided by the total time.
so unless you have the future end date (or a reasonable estimate), it would
be difficult to calculate a percent based on date.

regards
FSt1

"boiseman62" wrote:

I have 8 steps to a particular activity. I need to show the dates each step
is completed but I also need to determine the percent complete of the overall
activity. Any suggestions would be greatly appreciated.