PC Review


Reply
Thread Tools Rate Thread

Re: Calculated % completed by date

 
 
joeu2004
Guest
Posts: n/a
 
      8th Aug 2012
"kp56" <(E-Mail Removed)> wrote:
> So if a project begins 3/1/2012 and ends 9/1/2012, based
> on today's date what percent complete is it?


If the start date is in A1 and then end date is in A2, perhaps the following
will meet your needs:

=(TODAY() - A1) / (A2 - A1)

formatted as Percentage.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't want to see completed tasks except in "completed tasks" view CJ33414 Microsoft Outlook Discussion 1 2nd Oct 2009 01:05 AM
Any way to show completed calendar appointments as completed? Sinbad7 Microsoft Outlook Calendar 5 17th May 2008 11:50 PM
Problem: "Completed" field does not show completed date. =?Utf-8?B?UGhpbGw=?= Microsoft Outlook Discussion 6 12th Mar 2007 05:08 AM
RE: Report Date - Date Recv = Days Late, but how to rid completed date =?Utf-8?B?U2hhbmVEZXZlbnNoaXJl?= Microsoft Excel Worksheet Functions 0 25th Jan 2007 12:05 AM
display completed tasks in the calendar day they were completed =?Utf-8?B?SkpSYW1DSFM=?= Microsoft Outlook Calendar 2 5th Aug 2006 01:44 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:00 AM.