I have this formula and it is working up until I had to add one more criteria I need to check whether the date in column K3 is <= 1/1/1987. When I add the date to the formula, the date part isn't working.


=IF(OR(I3>="YES",J3="YES"),"YES","NO")

=IF(OR(I2>="YES",J2="YES", E2<= "1/1/1987"),"YES","NO")

Can anyone please help?

Thanks