=IF(H2I2,"Error","OK")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Durie" wrote in message
...
Hi
I have an inspection spreadsheet that has to be updated every 7 days, can
I
use the if function to count dates between 2 colums and then display an
error
message if it goes over 7 days in the second colum?
I was trying If=(hi:h225I1:I225thenK1) Ki is the error message
(Inspection due)