Try the below.

=(TODAY()-J2)/(K2-J2)%

If this post helps click Yes
---------------
Jacob Skaria


"deb" wrote:

Column J Column K
Project Start Project End
1-Jan-06 5-May-10

I need the percent complete as of todays date.

Any Ideas?
--
deb