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 vote248 views1 answer
Code for reading letters only in vb 6
VBA
0 vote228 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote230 views1 answer
Vba get relative cell address
VBA
0 vote212 views1 answer
Refresh token em vb net
VBA
15 votes269 views1 answer
Excel vba wait
VBA
0 vote238 views1 answer
Vba cell all borders
VBA
0 vote239 views1 answer
Vba horizontalalignment
VBA
0 vote227 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote202 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote221 views1 answer
Reset border color textbox vba
VBA