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 vote233 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote239 views1 answer
Excel vba cell on change
VBA
0 vote230 views1 answer
Vb check if row has column
VBA
0 vote251 views2 answers
Excel vba number format file size
VBA
1 vote221 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote240 views1 answer
Vba apostrophe chr
VBA
0 vote237 views1 answer
Vbscript check if string is empty
VBA
0 vote232 views1 answer
Vba loop through table
VBA
0 vote244 views2 answers
Open url from vba
VBA
0 vote245 views1 answer
Supprimer la valeur de celule vba
VBA