help with if formula

[Rubygas14]

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

[TABLE="width: 365"]
<tbody>[TR]
[TD]30/11/2018 21:10[/TD]
[TD][/TD]
[TD]03/12/2018
08:00[/TD]
[TD]Late[/TD]
[/TR]
</tbody>[/TABLE]

=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.