excel vba How to determine if a date falls on the weekend? code example Example: excel vba How to determine if a date falls on the weekend? MsgBox Weekday(MyDate, vbMonday) > 5