Dim mydate As String
mydate = Format(Date + 2, "dddd")
If mydate = "Saturday" Then msgbox="Saturday Entered"
If mydate = "Sunday" Then msgbox = "Sunday Entered"

"TCUser" wrote:

I am trying to find a way to validate a date entered in Excel as a weekday.
It would be helpful to warn the user if they try to enter a Saturday or
Sunday date and possible holidays.