+ Reply to Thread
Results 1 to 4 of 4

Percentage calculation Based on dates and remaining task 2013

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Percentage calculation Based on dates and remaining task 2013

    Good day,
    I am looking for help for the following formula:

    C2 = Numbers of task
    D2 = Start Date
    E2 = End Date
    F2 = Completed Task
    G2 = Remaining Task

    H2 = Total (Percentage)

    I need to make H2 = Base on my start date and end date, the remaining task from my main task. Wow I'm reading this and makes no sense...

    So I have lets says 10 task to do between the start date and end date. Each day I will complete a task. I have, in my column F2, a completed task. So each time I complete a task my remaining task changes. I would need to know what is the percentage of the remaining task based on the start date and end date.

    Does this make any sense?

    My Formula will be in H2
    Last edited by Excelnoub; 04-04-2014 at 06:52 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,426

    Re: Percentage calculation Based on dates and remaining task 2013

    Does this make any sense?
    Frankly, no! Please attach a workbook showing what you are expecting to see, preferably annotated.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Percentage calculation Based on dates and remaining task 2013

    Good day,
    Just received a concrete answer from my client.

    He needs to have the remaining percentage

    C2 = The number of total Task lets say 10
    F2 is the Completed Task lets say 2
    G2 is the remaining Task lets say 8

    I need in my H2 to equal 20%
    If all 10 are completed I need H2 to equal 100%

    I know I am doing something wrong cause it make no sense, I mean my Formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    What would be the right Formula?

    Thank you

  4. #4
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Percentage calculation Based on dates and remaining task 2013

    wow I feel so stupid I found it lol

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    added to my H2

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-29-2013, 04:49 PM
  2. Calculating dates based on 2013 calander
    By aleong in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2013, 11:17 AM
  3. Completed and remaining days count based on the dates range
    By krjoshi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2011, 01:59 PM
  4. Remaining days count based on the dates range
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2011, 11:47 AM
  5. Replies: 6
    Last Post: 04-25-2010, 03:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1