+ Reply to Thread
Results 1 to 6 of 6

IF Formula using multiple date factors

  1. #1
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    112

    IF Formula using multiple date factors

    Good morning,

    I'm having some trouble executing an IF formula that relies on a few different factors to determine if a project was completed by the due date or the adjusted due date, if applicable. See the attachment:

    Each project is assigned a due date however the due date can be adjusted so in some cases a project may have data entered for both a due date and an adjusted due date. When the project is complete, the completion date is entered. I need the final column to result in a yes or no response if either of these due dates was met. If the project is not yet complete this would remain blank.

    I attempted using an OR formula but am not yielding the results I had hoped for. In my example everything is coming back as Yes, however in my actual file I am receiving #Value errors on the cases that should be no using this same formula.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,625

    Re: IF Formula using multiple date factors

    Try

    =IF(C2="","",IF(OR(C2<=A2,C2<=B2),"Yes","No"))

  3. #3
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    112

    Re: IF Formula using multiple date factors

    Thank you John - this worked great in my test file but I was trying to figure out why I wasn't yielding the same results in my real file. I examined it a bit further and tested a similar condition I was seeing on my test file. If someone enter NA for not applicable in Column B when there is NOT an adjusted due date it looks like this changes the "No" results to "Yes" - Any idea how I can adjust this formula to include that?

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,625

    Re: IF Formula using multiple date factors

    Try

    =IF(C2="","",IF(AND(B2<>"",B2<>"NA",C2<=B2),"Yes",IF(C2<=A2,"yes","no")))

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,625

    Re: IF Formula using multiple date factors

    Or ...

    =IF($C2="","",IF(AND(ISNUMBER($B2),$C2<=$B2),"Yes",IF($C2<=$A2,"yes","no")))

  6. #6
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    112

    Re: IF Formula using multiple date factors

    Thank you this worked great!

+ 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] LOOKUP w/ multiple factors
    By mdt175 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2015, 06:18 PM
  2. If/Then formula with multiple factors
    By Marcis726 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-24-2014, 06:20 PM
  3. Replies: 0
    Last Post: 03-20-2013, 11:18 AM
  4. Replies: 6
    Last Post: 07-31-2009, 10:58 AM
  5. Multiple Factors in IF Function
    By bustanutti21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2008, 07:46 AM
  6. How do I format a formula to recognize multiple comparison factors
    By CandaceES in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-20-2006, 03:35 PM
  7. [SOLVED] Multiple IF factors
    By kamille824 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2005, 10:06 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