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

2 votes342 views1 answer
Vba uppercase first letter of each word
VBA
5 votes399 views1 answer
Excel vba get user selected range
VBA
13 votes500 views2 answers
Vba write text file
VBA
0 vote348 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote375 views1 answer
Add text to combobox drop down vb
VBA
2 votes364 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote373 views1 answer
Vba sheet hide unhide
VBA
0 vote352 views1 answer
Excel vba range contains
VBA
0 vote377 views1 answer
How to add line graph vb net
VBA
4 votes359 views1 answer
Excel vba how to get a range's full address including sheet name
VBA