Date percent complete as of today

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

 

[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

 

[Fred Smith]

=(today()-j2)/(k2-j2)
Format as percent

Regards,
Fred

 

[Jacob Skaria]

Try the below.

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

If this post helps click Yes