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 votes167 views1 answer
Vba file from path
VBA
1 vote157 views1 answer
Vba delete array element
VBA
0 vote171 views1 answer
Excel vba first working day month
VBA
0 vote192 views4 answers
How to continue formula in below line in vba code
VBA
0 vote174 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote182 views1 answer
Vba is integer
VBA
0 vote168 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote169 views1 answer
Vba text to general
VBA
0 vote167 views2 answers
Excel vba prevent save
VBA
0 vote170 views1 answer
Loop through all text boxes in a form vb
VBA