Day Of Week *SOLVED*

Is there a function similar to MonthName() to get the day of the week? I know there is WeekDay which returns a numeric number but i've already got the numeric number and I want to now get the day of the week. eg 1 would return Monday, 2 would return Tuesday.....

Not sure with your region, however try (WeekDayName):

VB Code:

MsgBox WeekdayName(Weekday(Date, vbMonday))

Bruce.

Thanks Bruce