Comparison of date and time

I have four cells where cell1 is in date format dd/mm/yyyy, cell2 is in hh:mm:ss , cell3 is in dd/mm/yyyy hh:mm:ss. Cell4 should dynamically produce a result based on the following condition:

if cell1+cell2 is less than cell3 then display message1 else message2.
How should i put this in a formula

Thankyou.

=IF(A1+B1<C1,"Message1","Message2")

M getting format error with this formula.

I applied this formula...
=IF((DATE(YEAR(M2),MONTH(M2),DAY(M2)))<(DATE(YEAR(P2),MONTH(P2),DAY(P2))),"No",IF(AND(DATE(T:T(M2),MONTH(M2),DAY(M2))=(DATE(YEAR(P2),MONTH(P2),DAY(P2))),(N2)<(TIME(HOUR(P2),MINUTE(P2),SECOND(P2)))),"No","Yes"))
where m2,n2 and p2 are cell1,cell2 and cell3 respectively.

Thanks so much for your help.

Formula:

Please Login or Register  to view this content.