Re: Calculated % completed by date

Discussion in 'Microsoft Excel Worksheet Functions' started by joeu2004, Aug 8, 2012.

  1. joeu2004

    joeu2004 Guest

    "kp56" <> 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.
     
    joeu2004, Aug 8, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    A end date and want to a calculated date from it with a %

    Guest, Mar 19, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    116
    Guest
    Mar 19, 2006
  2. Guest

    PivotTable:Using a calculated field result in another calculated f

    Guest, Jun 8, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    274
    Guest
    Jun 8, 2006
  3. Guest

    RE: Report Date - Date Recv = Days Late, but how to rid completed date

    Guest, Jan 24, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    226
    Guest
    Jan 24, 2007
  4. Guest

    Problem with Calculated Items on Calculated Fields.

    Guest, Mar 6, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    255
    Debra Dalgleish
    Mar 6, 2007
  5. SG

    Pivot: Calculated Field vs Calculated Item

    SG, May 27, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    322
Loading...

Share This Page