More then 2 conditions for Data Validation

[Pauljj]

I have a quandry, I need one cell for users to put in a date. The date can only be between todays date and the 31/12/12...I have set this up in Data Validation, so all ok, however. I now also need a warning message to pop if the date they enter is not a Sunday date. It should still let them continue though if they want to, or give them the opportunity to retry. Does anyone know how I could incorporate them both please

 

[Jonmo1]

I don't think you can do that with Data Validation...
It's purpose is to Allow or Dissallow certain values.
Not give the user the choice of using the value anyway...
At least not while preserving the Restriction of the Date Range...
If you set it to allow Sunday anyway, it would then also allow a date ouside your date range.

I would leave your validation as it is to restrict the date range.
But perhaps use Conditional Formatting to highlight the cell a certain color if it's on a Sunday..

 

[Dannyh1]

How about in another cell, say B1

=WEEKDAY(A1)

Then

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1")) Is Nothing Then
    If Range("B1") <> 1 Then
    Msgbox "Date entered is not a Sunday"
    End If
Else
    Exit Sub
End If
End Sub

 

[Pauljj]

thank you that works perfectly for me