Avatar of Andreamary
Andreamary
 asked on

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
Microsoft OfficeMicrosoft ExcelSpreadsheets

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon
Shums Faruk

Andrea,

This was simple :)  just to add <=
=IFERROR(IF($AH2="","",IF($AH2<=$AI2,"Yes","No")),"")
Andreamary

ASKER
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?
Shums Faruk

Show me the format of both the columns
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Shums Faruk

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Arana (G.P.)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Andreamary

ASKER
That did the trick! Thanks, Shums!
Shums Faruk

Pleased to help Andrea!

Arana great formula
Andreamary

ASKER
Hi Arana,

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

Andrea
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Arana (G.P.)

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.
Shums Faruk

Andrea,

Please request to re-open your question and split the points, Arana's solution is as helpful as mine.
Andreamary

ASKER
Thanks, Shums, I'll follow up...

Andrea
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Andreamary

ASKER
Thanks very much, Kyle!
Andreamary

ASKER
Thanks again to you both! And thanks, Shums, for arranging for the question to be reopened so I could share the points!

Cheers,
Andrea
Shums Faruk

You're Welcome Andrea! Glad we both were able to help you.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.