Access Weekday Function

Last updated: August 26, 2026.

The Weekday function returns a number identifying the day of the week for a date.

Syntax

Weekday(date [, firstdayofweek])

Argument	Description
`date`	Date expression
`firstdayofweek`	Optional constant defining which weekday is 1

Weekday(#8/26/2026#)               ' 4 when Sunday is first
Weekday(#8/26/2026#, vbMonday)     ' 3
DayNumber: Weekday([OrderDate], vbMonday)

Specify the first-day argument when reports must follow a defined calendar instead of the system default.

See Microsoft’s Access function reference for related expression functions.