+ Reply to Thread
Results 1 to 3 of 3

Percentage between dates, Complete, and Not Started... Multi-Conditional IF Statement?

  1. #1
    Registered User
    Join Date
    05-31-2018
    Location
    Atlanta, GA
    MS-Off Ver
    16.13.1 MAC
    Posts
    1

    Percentage between dates, Complete, and Not Started... Multi-Conditional IF Statement?

    My formula currently measures the percentage of completion between TWO dates based on a "current date" input. and IF the percentage is under 1 (or 100%) it does so
    If it is 100% or higher is says “Complete”
    Current Formula:
    O7 refers to Start Date, Q7 Finish Date, $E$3 Current Date

    =IF(DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d")<1,DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d"),"Complete")

    I need the formula to be altered to serve the SAME function as it calculates the percentage of completion between two dates (a START date and a FINISH date using the CURRENT date input) along with the function of it notifying me when it is the same date or exceeds the completion date (100%) by stating "complete"

    IN ADDITION to what is described above I would like the formula to:
    -somehow incorporate in the same formula something that also recognizes when the the "current date" input falls before the start date by notifying me that the task has "not started" in the same way the "complete" indicator does-
    - Possibly by seeing IF the START date > CURRENT date then "not started"

    If you need any clarification PLEASE ask me

    Any help will be greatly appreciated

    I am using Excel 16.13.1 Mac

    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,758

    Re: Percentage between dates, Complete, and Not Started... Multi-Conditional IF Statement?

    This should do the trick

    =IF(O7>$E$3,"Not Started",IF(DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d")<1,DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d"),"Complete"))
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

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

    Re: Percentage between dates, Complete, and Not Started... Multi-Conditional IF Statement?

    Thanks for the rep, and thanks for marking your thread Solved!

+ 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. Multi-Conditional IF + AND + ISNUMBER + FIND Statement
    By Aimee S. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2015, 06:42 PM
  2. [SOLVED] Trouble with a complex, multi-conditional % Complete formula
    By Aimee S. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2014, 02:02 PM
  3. [SOLVED] Multi conditional If statement. I think
    By rkm140 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2012, 09:59 PM
  4. Replies: 0
    Last Post: 10-11-2012, 11:38 AM
  5. Percentage Complete - Excel 2010 - dates comparison
    By Simon Evans in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2012, 04:57 AM
  6. Replies: 6
    Last Post: 02-13-2012, 03:52 AM
  7. Replies: 2
    Last Post: 11-02-2011, 12:49 PM

Tags for this Thread

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