|
|
|
|
Biff -
Thanks for the help!!
Mark
"Biff" wrote:
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?
|