"John Calder" wrote:
If the dates are across columns how would the formula look then?

Assuming dates are running across in row 2, from B2 across
Then in say, A1: =IF(MAX(2:2)<TODAY()-30,"DUE","")
Adapt the range to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---