Excel vba if sunday or staurday

MsgBox Weekday(my_date, vbMonday) > 5
' Or -------------------------------------------------------
Public Function IsWeekend(InputDate As Date) As Boolean
    Select Case Weekday(InputDate)
        Case vbSaturday, vbSunday
            IsWeekend = True
        Case Else
            IsWeekend = False
    End Select
End Function

Source: stackoverflow.com

Excel vba How to determine if a date falls on the weekend?

MsgBox Weekday(MyDate, vbMonday) > 5

Source: stackoverflow.com

Similar codes

0 vote122 views1 answer
Vba check 32 or 64 bit
VBA
0 vote125 views1 answer
Vbscript for loop
VBA
0 vote108 views1 answer
Excel vba open browser
VBA
31 votes153 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote119 views1 answer
Get month number from month name vbnet
VBA
-1 vote114 views2 answers
How close excel through visual basic
VBA
1 vote120 views1 answer
Vba delete file
VBA
5 votes139 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote123 views1 answer
How to set location and size of new from vb
VBA
0 vote118 views1 answer
Loop through all text boxes in a form vb
VBA