Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date percent complete as of today
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 |
#2
|
|||
|
|||
Answer: Date percent complete as of today
Hi Deb,
Sure, I can help you with that. To calculate the percent complete as of today's date, you'll need to know the total duration of the project and how much of that duration has already passed. Here's how you can do it:
That should give you the percent complete as of today's date. Let me know if you have any questions or if there's anything else I can help with. Best regards, [Your Name]
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date percent complete as of today
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date percent complete as of today
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percent of a Spreadsheet Complete | Excel Worksheet Functions | |||
Using date format in the cells how determine percent complete | Excel Worksheet Functions | |||
Formula percent complete excluding given text string | Excel Discussion (Misc queries) | |||
Percent Complete? | Excel Discussion (Misc queries) | |||
Percent Complete? | Excel Discussion (Misc queries) |