"John Calder" wrote
Thanks again Max

You're welcome, John

It appears to work ok except for one thing. When I delete all the data
from
the range the "DUE" still shows?
Is there a way I can have the formula cell return to blank when the data
has
been deleted?

Just use an IF trap in front, eg in A1:

=IF(MAX(2:2)=0,"",IF(MAX(2:2)<TODAY()-30,"DUE",""))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---