Day of the Week

Is there an "easy" way to consistantly determine the day of te week (Mon, Tue, Wed). There wouldn't happen to be a variable out there that carries it, like Date and Time do?

Thanks in advance

WeekDay Function returns the weekday number 1-7 of any date variable/String expression that is a valid date.

Will this help you?

Code:

---

Select Case Weekday("10/01/2001")
Case vbSunday
    MsgBox "Is Sunday"
Case vbMonday
    MsgBox "Is Monday"
Case vbTuesday
    MsgBox "Is Tuesday"
Case vbWednesday
    MsgBox "Is Wednesday"
Case vbThursday
    MsgBox "Is Thursday"
Case vbFriday
    MsgBox "Is Friday"
Case vbSaturday
    MsgBox "Is Saturday"
End Select

---

Thanks, I was JUST gonna post that I found it in MSDN Library. Thank you for the speedy responce though.

Hi! Planewalker99, This will more better and efficient

Code:

---

WeekdayName(Weekday("10/01/2001", vbUseSystemDayOfWeek))

---

Cheers!