+ Reply to Thread
Results 1 to 2 of 2

Calculate Percentage progress between two dates

  1. #1
    Registered User
    Join Date
    10-30-2018
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    0

    Calculate Percentage progress between two dates

    Hi guys.

    I need your help with the following.
    Excel 2013

    I am running a program that calculates the percentage of completion on a specific product.

    1. I need to check if the product has reached 40% on a specified date(If on time: "on time"in green OR If not ,then cell must show "Late" in red)

    So far i have the following
    A1 =Today()

    start date
    B2: 06/09/2018

    40% date - - 3 weeks later
    C2 : 27-09-2018

    Current Percentage 37% : Thus Late as today is 30-10-2018

    I have the following formula: =IF(D2>40,"ON TIME","LATE")
    Not sure how to incorporate the dates into this

    Please can someone help

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello SuperFlrares,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] Calculate progress between two dates
    By rjyusmc2005 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2020, 10:50 AM
  2. Progress Bar showing the count, rather than percentage
    By rcm242 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2017, 05:31 PM
  3. How to count progress percentage in a row excluding a value
    By Mrerosennin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-05-2017, 08:35 AM
  4. Calculate percentage between 2 dates with first date being =today()
    By Jade1987 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-11-2016, 06:25 AM
  5. [SOLVED] How to place and define progress bar with percentage
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 05-28-2014, 11:35 AM
  6. [SOLVED] Progress percentage function for student's grades
    By ckonsta in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2013, 02:17 AM
  7. percentage progress bar in vba
    By djwaz69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 10:34 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