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

5 votes175 views1 answer
Excel vba high word from Long Integer
VBA
22 votes346 views1 answer
Excel vba check if directory exists
VBA
0 vote184 views1 answer
Arq linux
VBA
0 vote169 views1 answer
Excel vba show developer tab
VBA
0 vote183 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote186 views1 answer
Putting marquee in vb.net
VBA
1 vote184 views1 answer
Excel vba autofit
VBA
0 vote183 views1 answer
Remove first character from string vb
VBA
4 votes175 views2 answers
Vba array length
VBA
0 vote183 views1 answer
Loop through all text boxes in a form vb
VBA