Comparing two date cells

[sobeitjedi]

Hi

I have a date in K (11/11/2019 17:20:35) and a date in D (11/11/2019)

I want to calculate if D was after or not on K.
My formula is =IF(K1<=D1,"yes","no")

This seems to work, expect in this example, where the dates are the same. Because the time is also in K, is doesn't see it as a match.

How to I fix my formula to make the calculation work?

 

[FormR]

Hi, try like this:

=IF(INT(K1)<=D1,"yes","no")

 

[sobeitjedi]

Yes! thank you