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 vote238 views1 answer
Vba get workbook name
VBA
0 vote260 views1 answer
Move bindingnavigator vb
VBA
0 vote245 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote231 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote237 views1 answer
Vba change named range address
VBA
0 vote232 views2 answers
Do until loop vba
VBA
2 votes225 views1 answer
Excel vba check if key is in collection
VBA
0 vote242 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote187 views1 answer
How to self delete a vbscript file
VBA
1 vote251 views1 answer
Vba format string as cash
VBA