# IF Formula using multiple date factors

1. ## 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.

2. ## Re: IF Formula using multiple date factors

Try

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

3. ## 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. ## Re: IF Formula using multiple date factors

Try

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

5. ## Re: IF Formula using multiple date factors

Or ...

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

6. ## Re: IF Formula using multiple date factors

Thank you this worked great!

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

#### 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