help with if formula

[Rubygas14]

Hi i have 2 dates and using the below formula due to different months this is not calculating correctly

30/11/2018 21:10

03/12/2018 08:00

Late

<tbody>
</tbody>

=IF(I3< l3,"ok","late")
<l3,"ok","late")
<l3,"ok","late")

<l3,"ok","late")[ 
Can Anyone Help 

Thanks</l3,"ok","late")[code]<l3,"ok","late")[></l3,"ok","late")

 

[jtakw]

That formula, will indeed convert the values to text.
Try this in place of the formula in post#1
=IF(DATEVALUE(I3)<DATEVALUE(L3),"Ok","Late")

Hi,

Fluff's formula got cut off:

=IF(DATEVALUE(I3) < DATEVALUE(L3),"Ok","Late")

 

[Fluff]

Thanks for that jtakw
I should know better by now & have corrected it.