Date percent complete as of today

D

deb

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?
 
C

cm

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
 
Top