Choice of Date or another field
 

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?

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?

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?