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 vote301 views1 answer
Vba range clear formatting
VBA
31 votes390 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote305 views1 answer
Vba open report
VBA
0 vote277 views1 answer
Vbs send keys
VBA
0 vote250 views1 answer
How to make a if statement with vbs
VBA
0 vote267 views1 answer
Excel vba milliseconds
VBA
0 vote269 views1 answer
Excel vba hide columns
VBA
31 votes391 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote277 views1 answer
Remove first character from string vb
VBA
1 vote289 views1 answer
Vba refresh pivot table
VBA