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 vote158 views1 answer
Vba pass named range to function
VBA
0 vote147 views1 answer
Excel vba disable screen update
VBA
2 votes163 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote163 views1 answer
Excel vba extract year
VBA
0 vote160 views1 answer
Vba is integer
VBA
1 vote169 views1 answer
Vba loop through files in folder
VBA
0 vote102 views1 answer
Vba select file in folder
VBA
1 vote166 views1 answer
Excel vba array remove first
VBA
0 vote168 views1 answer
Vba paste values
VBA
0 vote160 views1 answer
Vbnet line chart showing extra space
VBA