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")

 

[Special-K99]

Forum has corrupted your post, please edit and place spaces around any < > characters

 

[Fluff]

There's nothing wrong with that formula.
Check that your dates are real dates, rather than text.

 

[Rubygas14]

right i have checked the format and All are set to Date Format but still getting incorrect Data

Formula is

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

thanks

​

 

[Fluff]

If you format both cells as General, what do you see?

 

[Special-K99]

Use ISTEXT or ISNUMBER to determine if the dates are in fact numbers or text.

What are you comparing I3 against L3 ?

If I3 and L3 are numbers you should get "ok"
If I3 and L3 are text you will get "late"

 

[Rubygas14]

same just the date and time

 

[Fluff]

In that case they are text not date/time
You will need to convert them to genuine date/time

 

[Rubygas14]

i think i have found the problem just need help if i am right so I3,

30/11/2018 21:10 <
L3,

03/12/2018 08:00 which should show "OK" as it is true but the formula in L3 to get the Date is = IF(OR(K92=Hour),TEXT(Post,"dd/mm/yyyy")&TEXT(K92," "&"hh:mm"),TEXT(Pre,"dd/mm/yyyy")&TEXT(K92," "&"hh:mm")) Would that force to cell to show as text??

if so what could i use as this is in my macro and it goes in to an Formula Array..


i have just copied the values to seperate cells and tried the if formula and it works.

Also i have just realised if i f2 and enter on the I3 Cell it cal calculates but i have alot of data to do this with.

​

​

 

[Fluff]

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")<datevalue(l3),"ok","late")< html=""></datevalue(l3),"ok","late")<>