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

20 votes462 views1 answer
Excel vba factorial
VBA
1 vote318 views1 answer
Excel vba compare 2 rows
VBA
0 vote310 views1 answer
Get current url vb.net
VBA
-1 vote371 views1 answer
Vba sendkeys
VBA
0 vote324 views1 answer
Excel vba StartUpPosition
VBA
9 votes458 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
1 vote312 views1 answer
Excel vba autofit
VBA
0 vote305 views1 answer
Find days in month vba
VBA
0 vote339 views1 answer
Excel vba unlock sheet without password
VBA
0 vote326 views4 answers
How to continue formula in below line in vba code
VBA