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 vote178 views1 answer
Excel vba hide columns
VBA
0 vote240 views2 answers
VB
VBA
0 vote166 views1 answer
Change whcih control a user has selected vb
VBA
6 votes195 views1 answer
Excel vba isalpha
VBA
3 votes184 views1 answer
Vba double quote
VBA
0 vote178 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote174 views1 answer
Nested if else in vb.net
VBA
0 vote164 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote200 views1 answer
Vba is integer
VBA
20 votes343 views1 answer
Excel vba recursive example factorial function
VBA