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 vote239 views1 answer
Vba dictionary length
VBA
4 votes216 views1 answer
Excel vba how to reset usedrange
VBA
6 votes221 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote227 views1 answer
Filesystemobject vba reference
VBA
0 vote209 views1 answer
Vlookup columns not next to each other
VBA
5 votes245 views1 answer
Vba low word from Long Integer
VBA
0 vote211 views1 answer
Move bindingnavigator vb
VBA
0 vote206 views1 answer
Not allow form to be resized
VBA
0 vote219 views2 answers
Vba remove line breaks
VBA
0 vote217 views1 answer
(SecurityProtocolType)3072 vb.net
VBA