i use something like this, with DtVal being the variable holding the date

If Weekday(DtVal, 2) > 5 then


--


Gary


"Arne Hegefors" <ArneHegefors@discussions.microsoft.com> wrote in message
news:7C15C689-BC63-4A05-9BFE-70016946984E@microsoft.com...
> 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!
>