A date in excel is just a formatted number, so yoy can use a number to test
like if your range is A1:A10, select it with A1 as the active cell (if you
select from A1 it will be) , do datavalidationcustom and use

=OR(ISNUMBER(A1),A1="TBD")

you can validate for date but not add an extra condition under
validationdate etc

Regards,

Peo sjoblom

"Andrew Lindsay via OfficeKB.com" wrote:

I would like to use the data (menu) / validation to constrain the input to
a range of cells. I only want the user to be able to enter a date value OR
the phrase "TBD".

Is this possible using the validation tool?

If not, I'm open for suggestions on how to do this?

Thanks,
Andrew