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 vote338 views1 answer
Vb window.minimize
VBA
1 vote378 views1 answer
How to put a gridpain in a vbox
VBA
0 vote338 views1 answer
Excel R1C1 mode
VBA
0 vote340 views1 answer
Vbnet add new ecel sheet
VBA
0 vote384 views1 answer
Vba string
VBA
0 vote345 views1 answer
Sendkeys vba selenium
VBA
2 votes350 views1 answer
Vba round number
VBA
1 vote410 views1 answer
Perform http request in vb.net
VBA
0 vote358 views1 answer
VBA Sort RossetaCode
VBA
-1 vote339 views1 answer
Text to speech vb.net
VBA