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

8 votes518 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote239 views1 answer
Average vba
VBA
0 vote238 views1 answer
Vba collection key list
VBA
0 vote273 views1 answer
Vba ternary
VBA
0 vote220 views1 answer
Vba file size
VBA
0 vote231 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote243 views1 answer
Vba first line of string
VBA
1 vote224 views1 answer
Excel vba hide zero values
VBA
0 vote276 views1 answer
.net crash app
VBA
1 vote226 views1 answer
Vba ubound array 2-dimensional
VBA