Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not weekday
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not weekday
Arne,
Try this: Debug.Print Weekday(Now(), vbSunday) There are a few options for the 2nd argument, depending what you want. NickHK "Arne Hegefors" ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not weekday
On Wed, 16 Aug 2006 06:10:03 -0700, Arne Hegefors
wrote: 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! What was the problem with the answers that were posted to you same question about an hour ago? It would be useful to give the results of those attempts, before just blindly repeating the question. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weekday() help please? | New Users to Excel | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
WEEKDAY() | New Users to Excel | |||
Weekday | Excel Worksheet Functions | |||
Weekday | Excel Discussion (Misc queries) |