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.