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

1 vote254 views1 answer
Vba login website
VBA
0 vote247 views1 answer
Open file dialog in vb.net
VBA
0 vote245 views1 answer
Search in richtextbox vb.net
VBA
-1 vote294 views1 answer
Vba sendkeys
VBA
0 vote238 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote240 views2 answers
Excel vba protect cells with formula
VBA
0 vote239 views1 answer
Hello world vb.net
VBA
32 votes335 views2 answers
Excel vba column letter
VBA
0 vote288 views1 answer
How to call gcd in vba
VBA
0 vote262 views1 answer
Vba random number
VBA