Choice of Date or another field

M

Mark

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?
 
B

Biff

Hi!

Try this:

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

Format cell as DATE

Biff
 
Top