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 vote141 views1 answer
Vba table header name
VBA
1 vote141 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote114 views1 answer
Le contrôle SpinButton (Toupie)
VBA
1 vote121 views1 answer
Excel vba hide zero values
VBA
0 vote113 views1 answer
Remove frist letter from string vbnet
VBA
0 vote127 views1 answer
Excel vba prevent saving workbook
VBA
0 vote122 views1 answer
Vbnet line graph smooth lines
VBA
0 vote121 views1 answer
Do while not vb.net
VBA
0 vote114 views1 answer
Vbnet add new ecel sheet
VBA
7 votes132 views1 answer
Vba array declaration
VBA