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 vote157 views1 answer
Build an index all files of a FTP site
VBA
0 vote156 views1 answer
Excel run macro every 5 minutes
VBA
2 votes102 views1 answer
Excel vba pause
VBA
0 vote153 views1 answer
Excel vba linter
VBA
0 vote149 views1 answer
WGET FTP
VBA
0 vote153 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
1 vote153 views1 answer
Excel vba force recalculation
VBA
8 votes145 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote143 views1 answer
Vbnet line graph smooth lines
VBA
0 vote147 views1 answer
Vba open report
VBA