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 vote305 views1 answer
Vbnet get file name from path
VBA
0 vote342 views1 answer
Move bindingnavigator vb
VBA
5 votes358 views1 answer
Xlvba double quotes in string literal
VBA
0 vote312 views1 answer
Excel vba protect content
VBA
0 vote345 views1 answer
Vba nested dictionary
VBA
3 votes304 views1 answer
Vba make long from two shorts
VBA
1 vote351 views1 answer
Excel vba get column number from column name
VBA
0 vote327 views4 answers
Jwt token vb.net validation
VBA
0 vote312 views1 answer
Vbscript for loop
VBA
0 vote297 views1 answer
Vbs send keys
VBA