Question : excel vba if sunday or staurday
Answered by : vastemonde
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 : https://stackoverflow.com/questions/1580432/how-to-determine-if-a-date-falls-on-the-weekend | Last Update : Tue, 09 Feb 21
Question : excel vba How to determine if a date falls on the weekend?
Answered by : daniel-ferry
MsgBox Weekday(MyDate, vbMonday) > 5
Source : https://stackoverflow.com/a/33115260/3566998 | Last Update : Wed, 01 Apr 20