Thanks again Max

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?

Thanks


"Max" wrote:

Typo, line:
Assuming dates are running across in row 2, from B2 across

should read as:
Assuming dates are running across in row 2, from A2 across
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---