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?


    John

  • Re: Validating for Weekday Date OR Text


    Quote from crushdrinker06;768594

    jzehr,


    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!

Participate now!

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