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 vote191 views1 answer
VB Error Code BC30201
VBA
0 vote197 views2 answers
Excel vba protect cells with formula
VBA
0 vote193 views1 answer
Excel vba copy entire sheet paste values
VBA
3 votes214 views1 answer
Extract word in a text in excel
VBA
0 vote231 views1 answer
Winforms dark title bar
VBA
0 vote193 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote173 views1 answer
Excel protect cells with formulas
VBA
31 votes390 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote186 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
3 votes192 views1 answer
Extract the nth word from a text string
VBA