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 vote197 views1 answer
Vb net check if file exists
VBA
4 votes225 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote196 views1 answer
Excel vba disable copy paste
VBA
20 votes512 views1 answer
Excel vba factorial
VBA
0 vote191 views1 answer
Excel protect cells with formulas
VBA
1 vote211 views1 answer
Excel vba force recalculation
VBA
0 vote210 views4 answers
How to continue formula in below line in vba code
VBA
1 vote198 views1 answer
Excel vba first and last row and column in range
VBA
0 vote212 views1 answer
Vba apostrophe chr
VBA
0 vote198 views1 answer
Vbnet check if string is only symbols
VBA