Hello! I have a piece of code that I want to use to check if a certain date is not a weekday, i.e. Saturday or Sunday. The date is found in the first position of an array. Code:

If (Day(strStartDatumArray(0)) = 1 Or 7) Then

MsgBox ("not a weekday")

End If

Problem: I get the message that it is not a weekday regardless of what day it actually is. Can anyone please see what is wrong with this code Thanks very much in advance!

replace "Day" with "Weekday" and change the if to:

If Weekday(testdate) = 1 Or Weekday(testdate) = 7 Then
MsgBox ("Weekend")
End If

Chas