Closed Thread
Results 1 to 6 of 6

Calculate progress between two dates

  1. #1
    Registered User
    Join Date
    01-21-2015
    Location
    ky
    MS-Off Ver
    2013
    Posts
    4

    Question Calculate progress between two dates

    Is there a formula or function that will take a starting date in the past, an ending date in the future, and give you the progress between them for today's date?

    Example:
    Starting date 8/1/2015
    Ending date 8/10/2015
    Todays date 8/5/2015
    50% complete
    Last edited by rjyusmc2005; 09-09-2015 at 06:42 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Calculate progress between two dates

    Try:

    =(DATEDIF(A1,TODAY(),"d")+1)/(DATEDIF(A1,B1,"d")+1)

    A1 is your start date

    B1 is your end date
    If I've helped U pls click on d *Add Reputation

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Calculate progress between two dates

    A few things to note:

    1. For some reason DATEDIF is undocumented in Excel but Microsoft describes it in their support pages. You won't see it in Excel in the list of available functions but it is there.

    2. Using DATEDIF with "d" is basically like doing plain subtraction, since dates are stored as number of days. The following formula will give the same results as the one above:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    3. If you are doing something for work and just want to include working days, instead of all days, use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    01-21-2015
    Location
    ky
    MS-Off Ver
    2013
    Posts
    4

    Re: Calculate progress between two dates

    Thanks. That worked perfectly.

  5. #5
    Registered User
    Join Date
    08-09-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    10

    Re: Calculate progress between two dates

    Thanks for posting the formulas for calculating the progress % between two dates. The =(DATEDIF(A1,TODAY(),"d")+1)/(DATEDIF(A1,B1,"d")+1) formula works perfectly in my MSExcel Gantt Chart.

    However, if the start date is greater than today, the formula returns an #NUM error. How can I modify this formula so that if the start date is greater than today, the formula returns a BLANK "" or 0%?

    Thank you!!!

  6. #6
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Calculate progress between two dates

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    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.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need formula: progress (% completion) between two dates
    By bsafra1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 09:53 AM
  2. Replies: 1
    Last Post: 08-06-2014, 10:29 PM
  3. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 01-08-2014, 02:40 AM
  4. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 12:41 PM
  5. [SOLVED] Conditional Formatting - Progress Bar based on dates in row
    By RichTea88 in forum Excel General
    Replies: 3
    Last Post: 01-24-2013, 08:50 AM
  6. Calculate Selected Cells Only - With Progress Indicator
    By WiggleMuncher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2012, 05:50 PM
  7. Calculate Selection Progress Bar
    By fervorking in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2011, 01:39 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