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

3 votes286 views1 answer
Excel vba change format of cell
VBA
0 vote297 views4 answers
How to continue formula in below line in vba code
VBA
0 vote372 views1 answer
Vba vbcrlf chr
VBA
0 vote295 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote291 views1 answer
Delete rows in excel vba code
VBA
0 vote291 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
2 votes271 views1 answer
Date format for ms chart vb.net
VBA
5 votes304 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote331 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote281 views1 answer
Excel vba autofit
VBA