Returns a string representing the day of the week.
Syntax WeekdayName ( number, [abbreviate], [firstdayofweek] ) Key date Any valid date expression.
abbreviate Abbreviate the weekday name? TRUE /FALSE. firstdayofweek A constant that specifies the first day of the week, default=vbSunday.
The WeekdayName() function can be used in VBA or in an SQL query. The vb constants can only be used in VBA.
Dim strDay as String
strDay = weekdayname(2)
'will return Monday
“Go girl, seek happy nights to happy days” ~ William Shakespeare
Date - Return the current date.
MonthName - Return a string representing the month.
Format - Format a Number/Date/Time.
Weekday - Return the weekday (1-7) from a date.