Validation- if date input is a Sunday

[johnnywinter]

I would like to use Validation to verify that the date entered in cell "B3" is a Sunday.


Or do I have to go at this some other way?

[JBeaucaire]

Not sure about DATA VALIDATION, but you could do it with CONDITIONAL FORMATTING....make the cell light up if it IS a SUNDAY.

Highlight the cell, FORMAT > CONDITIONAL FORMATTING > Condition1 > Formula Is: =WEEKDAY(B3)=1

...and set your highlight color for when it is a Sunday, like Green if this is a good thing.

Alternately, you could set it to turn red if it's any day other than Sunday with:

=WEEKDAY(B3)<>1

[JBeaucaire]

I just experimented and the same formula works for DATA VALIDATION, too. Just choose "custom" and enter:

=WEEKDAY(B3)=1

You can customize the error message to indicate it's not a Sunday.

[johnnywinter]

My formula was close, but your's was perfect!

It worked in Validation.

Thank you

[JBeaucaire]

Awesome. If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]