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
This was simple :) just to add <=
=IFERROR(IF($AH2="","",IF(