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)

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

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
HIS


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