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 vote135 views1 answer
Vba apostrophe chr
VBA
0 vote133 views1 answer
Vb window.minimize
VBA
0 vote148 views1 answer
Vbnet click on dgv cells
VBA
0 vote145 views1 answer
Excel vba DisplayAlerts
VBA
0 vote143 views1 answer
Not allow form to be resized
VBA
5 votes153 views1 answer
Vba low byte from INTEGER
VBA
0 vote130 views1 answer
Type excel.application is not defined vb
VBA
0 vote150 views1 answer
Thread sleep vb
VBA
0 vote142 views1 answer
Vb.net visible property dgv collumn not working
VBA
3 votes137 views1 answer
Vba request json
VBA