Add a condition to an Excel formula to include when date in one cell equals date in another cell

Column AH = Date WO was completed
Column AI = Deadline date

My formula below indicates whether the WO was completed by the deadline or not:

=IFERROR(IF($AH2="","",IF($AH2<$AI2,"Yes","No")),"")

I need the above formula to be modified to include the additional condition below:

If AH2 = AI2, the result is also 'Yes' (the deadline was met)

Thanks!
Andrea
AndreamaryAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsDistinguished Expert - 2017Commented:
Andrea,

This was simple :)  just to add <=
=IFERROR(IF($AH2="","",IF($AH2<=$AI2,"Yes","No")),"")
0
AndreamaryAuthor Commented:
Thanks for the quick response, Shums! For some reason, the results I'm getting are still showing the deadline isn't met if AH2 = AI2. It appears that column AH includes a date and time stamp, whereas column AI only includes the date. Is it possible for the formula to ignore the time stamp, and if so, do you think that would resolve the issue?
0
ShumsDistinguished Expert - 2017Commented:
Show me the format of both the columns
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ShumsDistinguished Expert - 2017Commented:
If that's the case, then try below:
=IFERROR(IF($AH2="","",IF(TEXT($AH2,"dd-mm-yyyy")<=TEXT($AI2,"dd-mm-yyyy"),"Yes","No")),"")
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aranaCommented:
try this:
=IFERROR(IF($Ah2="","",IF(DATEVALUE(TEXT($Ah2,"DD/MM/yy"))<=$ai2,"Yes","No")),"")
1
AndreamaryAuthor Commented:
That did the trick! Thanks, Shums!
0
ShumsDistinguished Expert - 2017Commented:
Pleased to help Andrea!

Arana great formula
0
AndreamaryAuthor Commented:
Hi Arana,

I'm sorry, but I had already closed the question before I saw your response, which also worked. Thanks very much!

Andrea
0
aranaCommented:
Nothing to be sorry about, glad it worked, it was in fact Shum's answer just adjusted for your comment about time stamp, all credit goes to him, just wanted to give you an alternate way to do it , as a future reference.
0
ShumsDistinguished Expert - 2017Commented:
Andrea,

Please request to re-open your question and split the points, Arana's solution is as helpful as mine.
0
AndreamaryAuthor Commented:
Thanks, Shums, I'll follow up...

Andrea
0
AndreamaryAuthor Commented:
Thanks very much, Kyle!
0
AndreamaryAuthor Commented:
Thanks again to you both! And thanks, Shums, for arranging for the question to be reopened so I could share the points!

Cheers,
Andrea
1
ShumsDistinguished Expert - 2017Commented:
You're Welcome Andrea! Glad we both were able to help you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.