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 vote377 views1 answer
Vbnet round to nearnest thousand
VBA
1 vote349 views1 answer
How to remove zeros in excel
VBA
0 vote341 views1 answer
Vba collection key list
VBA
0 vote368 views1 answer
Vba ternary
VBA
0 vote479 views1 answer
Vba array of integers
VBA
0 vote320 views1 answer
Vba add month to date
VBA
0 vote361 views1 answer
Excel vba urlmon
VBA
0 vote355 views1 answer
Remove last 8 characters from string vb
VBA
0 vote331 views1 answer
Vbs
VBA
1 vote364 views1 answer
Vb.net get name by Cell Click
VBA