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 vote236 views1 answer
Vba variable number of arguments
VBA
1 vote219 views1 answer
Highlight selected cell in excel vba
VBA
0 vote221 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote211 views1 answer
Vba word pdf table to excel
VBA
0 vote230 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote220 views1 answer
Excel vba clear filter
VBA
1 vote247 views1 answer
Vba loop through files in folder
VBA
0 vote229 views1 answer
Openfiledialog specific folder
VBA
0 vote233 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote222 views2 answers
Excel vba close without saving
VBA