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