Validating for Weekday Date OR Text

  • 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?


  • Re: Validating for Weekday Date OR Text

    Quote from crushdrinker06;768594


    Try the code below

    That worked perfectly. Thank you for your prompt and excellent help!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!