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?
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.

ShumsExcel & VBA ExpertCommented:
Andrea,

This was simple :)  just to add <=
=IFERROR(IF($AH2="","",IF($AH2<=$AI2,"Yes","No")),"")
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?
ShumsExcel & VBA ExpertCommented:
Show me the format of both the columns
Ensure Business Longevity with As-A-Service

Using the as-a-service approach for your business model allows you to grow your revenue stream with new practice areas, without forcing you to part ways with existing clients just because they don’t fit the mold of your new service offerings.

Download eBook
ShumsExcel & VBA ExpertCommented:
If that's the case, then try below:
=IFERROR(IF($AH2="","",IF(TEXT($AH2,"dd-mm-yyyy")<=TEXT($AI2,"dd-mm-yyyy"),"Yes","No")),"")

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")),"")
AndreamaryAuthor Commented:
That did the trick! Thanks, Shums!
ShumsExcel & VBA ExpertCommented:
Pleased to help Andrea!

Arana great formula
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
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.
ShumsExcel & VBA ExpertCommented:
Andrea,

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

Andrea
AndreamaryAuthor Commented:
Thanks very much, Kyle!
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
ShumsExcel & VBA ExpertCommented:
You're Welcome Andrea! Glad we both were able to help you.
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.