Start date in A1

End date in A2

In A3 enter =(TODAY()-A1)/(A2-A1)

Format to percentage.


Gord Dibben MS Excel MVP

On Tue, 11 Sep 2007 09:02:04 -0700, AMQ wrote:

I am creating a worksheet to measure completion of a project/order. What
formula/function can I use to figure out the percentage of completion? I
have formulas for start/end days, but don't know where to go from there....