Last updated: August 26, 2026.
The WeekdayName function returns the localized name of a weekday number.
Syntax
WeekdayName(weekday [, abbreviate [, firstdayofweek]])| Argument | Description |
|---|---|
weekday | Number from 1 through 7 |
abbreviate | True for an abbreviated name |
firstdayofweek | Optional constant defining which weekday is 1 |
Examples
WeekdayName(1) ' Sunday by default
WeekdayName(1, True, vbMonday) ' Mon
DayLabel: WeekdayName(Weekday([OrderDate], vbMonday), False, vbMonday)Use the same first-day setting in Weekday and WeekdayName. Returned names follow the system locale.
See Microsoft’s Access function reference for related expression functions.
