Thread: Date percent complete as of today
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Date percent complete as of today
=(today()-j2)/(k2-j2)
Format as percent

Regards,
Fred

"deb" wrote in message
...
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

Reply With QuoteReply With Quote