Hi!

Try this:

=IF(ISNUMBER(MATCH("TBD",B1:B30,0)),"TBD",MAX(B1:B 30))

Format cell as DATE

Biff

"Mark" wrote in message
...
I have a column which is used for component completion date. The latest
date is teh complition date for teh project. I am using MAX(field:field)
to
select the latest date. However, we are running across the occurance
where a
date is TBD(to be determined) How can I choose the TBD if it is present
in
the column over the max date?