is weekday  
Author Message
AndersBank





PostPosted: Visual Basic for Applications (VBA), is weekday Top

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!



Microsoft ISV Community Center Forums1  
 
 
ChasAA





PostPosted: Visual Basic for Applications (VBA), is weekday Top

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

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

Chas