Thread: Not weekday
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Not weekday

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

If Weekday(DtVal, 2) 5 then


--


Gary


"Arne Hegefors" wrote in message
...
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!