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 vote141 views1 answer
Send webhook vbscript
VBA
0 vote138 views1 answer
Vbnet get file name from path
VBA
0 vote139 views1 answer
Returns an array from function vba
VBA
22 votes278 views1 answer
Xl vba check for folder
VBA
27 votes269 views2 answers
Vba check if file exists
VBA
0 vote150 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote131 views1 answer
Add Formula to Shape Text in VBA
VBA
3 votes147 views1 answer
Vba http request json
VBA
0 vote137 views1 answer
Vb streamreader
VBA
1 vote139 views1 answer
Close form vba
VBA