I'm trying to determine if I can validate for two different types of entry. I'd like a cell to either be a WEEKDAY date or "TBD"
I've tried the following:
=OR(AND(WEEKDAY(A2) <> 1, WEEKDAY(A2) <> 7),A2="TBD")
but it returns #VALUE! when I enter TBD
I've seen other methods of accepting both numbers OR text but I can't get Date OR Text to work. Is it possible?