Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |