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(
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
Column AI = Deadline date
My formula below indicates whether the WO was completed by the deadline or not:
=IFERROR(IF($AH2="","",IF(
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
Last Comment
Shums Faruk
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?
Show me the format of both the columns
ASKER CERTIFIED SOLUTION
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.
SOLUTION
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.
ASKER
That did the trick! Thanks, Shums!
Pleased to help Andrea!
Arana great formula
Arana great formula
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
I'm sorry, but I had already closed the question before I saw your response, which also worked. Thanks very much!
Andrea
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.
Andrea,
Please request to re-open your question and split the points, Arana's solution is as helpful as mine.
Please request to re-open your question and split the points, Arana's solution is as helpful as mine.
ASKER
Thanks, Shums, I'll follow up...
Andrea
Andrea
ASKER
Thanks very much, Kyle!
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
Cheers,
Andrea
You're Welcome Andrea! Glad we both were able to help you.
This was simple :) just to add <=
=IFERROR(IF($AH2="","",IF(