Duh! Thanks. I didn't think of going about it that way.

I did expand on your idea a little by forcing them to enter a value equal
to or greater than today, but less than 180 out.

=OR(AND(A1=TODAY(),A1<TODAY()+180),A1="TBD")

Thanks!
Andrew