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 vote168 views1 answer
Excel vba urlmon
VBA
0 vote168 views1 answer
Excel vba calculate
VBA
0 vote182 views1 answer
Vba round to 2 decimals
VBA
0 vote180 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote158 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote157 views1 answer
Excel vba disable copy paste
VBA
0 vote178 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote161 views1 answer
Excel vba ternary
VBA
0 vote204 views1 answer
Vbnet add axis labels to chart
VBA
1 vote163 views1 answer
Vba date to unix timestamp
VBA