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 vote224 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote203 views1 answer
Excel vba concatenate range
VBA
0 vote236 views1 answer
Find if year is leap year vb
VBA
6 votes226 views1 answer
Excel vba get the path of current workbook
VBA
4 votes208 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote230 views1 answer
Vba exit while
VBA
0 vote206 views1 answer
Vba copy paste value only
VBA
0 vote247 views1 answer
Excel vba scroll to cell
VBA
1 vote216 views1 answer
Excel vba get ordinal number from cardinal number
VBA
2 votes208 views2 answers
Excel vba copy values range to another range
VBA