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 vote183 views1 answer
Label de tableau dans des label.text en VBA
VBA
1 vote197 views1 answer
Vba loop through files in folder
VBA
0 vote198 views1 answer
How to mount floppy disks in vb.net
VBA
1 vote187 views1 answer
Vba compile error object required
VBA
4 votes185 views2 answers
Vba last row
VBA
0 vote198 views1 answer
Excel vba textbox forecolor disabled
VBA
6 votes184 views1 answer
Excel vba isalpha
VBA
1 vote219 views1 answer
Excel vba get column number from column name
VBA
0 vote184 views1 answer
Vba get application version
VBA
0 vote186 views1 answer
Vba timestamp -- milliseconds
VBA