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 vote290 views1 answer
Visual basic run command
VBA
0 vote253 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote237 views1 answer
Returns an array from function vba
VBA
5 votes264 views1 answer
Excel vba how to unit test vba code
VBA
0 vote231 views1 answer
How to extract a file from an ISO:
VBA
0 vote216 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote243 views1 answer
Open file dialog in vb.net
VBA
0 vote233 views1 answer
Set column width of datagridview vb.net
VBA
0 vote225 views1 answer
Excel vba populate array with cell values
VBA
0 vote221 views1 answer
Hello world vb.net
VBA