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 vote190 views1 answer
Vba find sub dictionary
VBA
0 vote198 views1 answer
Excel protect cells with formulas
VBA
0 vote208 views2 answers
Vba remove line breaks
VBA
-1 vote184 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote181 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote187 views1 answer
Vb test if reference is null
VBA
2 votes187 views1 answer
Vba array contains
VBA
1 vote209 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
1 vote211 views1 answer
Add rows to datagridview vb.net
VBA
0 vote194 views1 answer
Vbnet dynamically change excel sheet name
VBA