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

1 vote175 views1 answer
Excel vba autofit
VBA
2 votes160 views1 answer
Date format for ms chart vb.net
VBA
1 vote169 views1 answer
Excel vba get column name from number
VBA
1 vote166 views2 answers
Vba find last row in range for certain criteria
VBA
1 vote189 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote166 views1 answer
Vba test optional argument
VBA
22 votes307 views1 answer
Xlvba check for folder
VBA
3 votes171 views1 answer
Vba request json
VBA
15 votes309 views2 answers
Xl vba dynamic string array
VBA
13 votes315 views2 answers
Vba write text file
VBA