If function

[Durie]

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:h225>I1:I225thenK1) Ki is the error message
(Inspection due)

 

[Bob Phillips]

=IF(H2>I2,"Error","OK")

--
HTH

Bob Phillips

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

 

[Nick Hodge]

Durie

I'm not sure of you references, but if the start date is in A1 and the due
date is in B1 then in C1 enter

=IF((B1-A1)>7,"Overdue","")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]