applying 2 or more data validation on the same column

[lezawang]

Hi
I have a Date column. I created DV list so user can select date from the list (the list has all dates of the year). Can I create another DV rule that prevent user from entering/selecting date which is weekend? I was thinking of creating costume formula
=AND(weekday(a1)<>6, weekday(a1)<>7). Thank you.

 

[My Aswer Is This]

Why not just use this script to only enter Workdays in column A for the entire year:

Sub WeekDays()
'Modified  9/30/2018  11:57:48 AM  EDT
Dim i As Long
Dim x As Long
    For i = 1 To 365
        ans = DateAdd("d", i - 1, "1/1/" & Year(Date))
        aa = Weekday(ans)
            If aa <> 7 And aa <> 1 Then
            x = x + 1
            Cells(x, 1).Value = ans
            End If
    Next
    
    With Columns(1)
        .NumberFormat = "DDDD,MMMM,DD,YYYY"
        .Font.Size = 16
        .AutoFit
        .HorizontalAlignment = xlLeft
    End With
    End Sub