Re: Validating for Weekday Date OR Text
Quote from crushdrinker06;768594jzehr,
Try the code below
=OR(IFERROR(AND(WEEKDAY(A2) <> 1, WEEKDAY(A2) <> 7),FALSE),A2="TBD")
That worked perfectly. Thank you for your prompt and excellent help!
Re: Validating for Weekday Date OR Text
Quote from crushdrinker06;768594jzehr,
Try the code below
=OR(IFERROR(AND(WEEKDAY(A2) <> 1, WEEKDAY(A2) <> 7),FALSE),A2="TBD")
That worked perfectly. Thank you for your prompt and excellent help!
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?
John