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.

« Re: Date Format | How to extract separated text by many commas in Excel? »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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