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 vote157 views1 answer
Vlookup columns not next to each other
VBA
0 vote165 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote186 views1 answer
Excel vba move down to next visible cell
VBA
0 vote150 views1 answer
How to set location and size of new from vb
VBA
4 votes174 views1 answer
VBA Deep Clone Dictionary
VBA
22 votes313 views1 answer
Xl vba check for folder
VBA
0 vote159 views1 answer
Excel vba saveas no prompt for overwrite
VBA
5 votes177 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote161 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote160 views1 answer
Excel vba prevent saving workbook
VBA