assuming your column headers are in row 1, try this: (replace the 1000 with
the last row in your range

=COUNTIF(K2:K1000,"<="&TODAY())/COUNTA(J2:J1000)


--- format this cell as percentage


--
hope to help,
cm


"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