Assuming dates are running down in col A
Then in say, B1:=IF(MAX(A:A)<TODAY()-30,"due","")
Adapt the range to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John Calder" wrote:
Hi
I run Win2k with Excel 2K
I would like to have a formula that looks at a range of dates, then
determines the "latest" date in that range. Then if that "latest" date is
greater than 30 days from the "current" date, display a message "DUE".
If your require anymore info please let me know.
Thanks
John